Run SQL Scripts - add "bind:" prefix/command like VScode/Db2i

Using ? parameter markers or :host-variables in ACS RSS is great, but the Db2i extension for VScode has implemented a "bind:" line-prefix / statement which helps a lot, when copying SQL statements from an RPG program source, to try them.

Here an example:

select * from table where col1 = ? and col2 = ?;
bind: 'ABC' 123;
bind: 'DEF' 456;

When the SQL statement is executed, it detects that a "bind:" line follows, and instead prompting for values, it uses the values on the "bind:" line separated by white-space and in the sequence they appear.

If a "bind:" line is executed, it should search backwards in the script, until it finds an executable SQL statement, and then bind the parameters/host-variables from the selected "bind:".

It also works with host variables:

select * from table where col1 = :var1 and col2 = :var2;
bind: 'ABC' 123;
bind: 'DEF' 456;

In addition it should also work with named bind parameters - which should override the sequence:

select * from table where col1 = :var1 and col2 = :var2;
bind: var2=123 var1='ABC';
bind: var1='DEF' var2=456;

And it should bind named parameters correctly by name - even when a :host-variable is used more than once.

select * from table where col1 = :var1 or col3 = :var1;
bind: var1='ABC';
bind: var1='DEF';

Here the value of "var1=" is used 2 times in the statement - even as it is only listed once in the "bind:" line.

This feature would help developers, copying SQL statements from SQLRPGLE programs - and it would be a great addition to RSS. It would also complement ideas IBMI-I-4651 and IBMI-I-4640.