Add interpolated variables

[mcamou]

Is your feature request related to a problem? Please describe.
No

Describe the solution you'd like

It would be great to have the possibility of having interpolated values in the query editor, which you could somehow assign (via a pull-down? That would be awesome). In my case, we have a DB with similarly-named tables which differ in the prefix, and I sometimes do queries like such as this (this is a very simplified version):

SELECT * FROM foo_abc WHERE x NOT IN (SELECT x FROM foo_def);

It would be really great to be able to do something like:

-- @var prefix=foo
SELECT * FROM #prefix#_abc WHERE x NOT IN (SELECT x FROM foo_def);

and if #prefix# is not defined in the file, you could pop up a dialog (or, if you want to be really fancy, you could somehow define it as a list, and the dialog could put up a pull-down list)

This would be just text interpolation, nothing smart like adding quotes where needed.

Describe alternatives you've considered

What I usually do is select the whole set of queries and search/replace.

Additional context

[jessereitz]

@mcamou FYI this is already implemented with sqltools.queryParams.enableReplace and sqltools.queryParams.regex, it's just not very well documented

[gjsjohnmurray]

PR #1064 from @lucasvieirasilva has implemented this. It is in today's 0.27.0 release.

[diego-vicente]

Hi! Just came accross this issue, and regarding what @mcamou said:

It would be really great to be able to do something like:

-- @var prefix=foo
SELECT * FROM #prefix#_abc WHERE x NOT IN (SELECT x FROM foo_def);

Is that actually implemented but not documented? Or are the interpolated variables only to be used from the connection settings?

[gjsjohnmurray]

@diego-vicente AFAIK you can currently only pre-define variable values in the connection definition, not in comments above the query.