Binding value in SQLite

[Yari27]

Is your feature request related to a problem? Please describe.
Can't run SQL query width binding values.

Describe the solution you'd like
Open dialog window to provide binding value.

Additional context
https://www.sqlite.org/c3ref/bind_blob.html
https://www.databasestar.com/sql-bind-variables/

[bart-schaefer]

For MySQL backend, it works to put 2 separate lines in the query editor:

set @id1 = 12345;
select * from table1 where idcolumn = @id1;

Have you tried this for SQLite?

It's true that the ? placeholder syntax does not work in Antares + MySQL. Since those represent ordinal positions, it would likely be necessary to count the unquoted ? and prompt in the dialog window for one value for each. Matching up corresponding data types might be an additional complication.