antares-sql
Binding value in SQLite
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/
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.
