Prompt user to supply host/bind variable values when Running SQL with host vars

[forstie]

For example... prompt on the :h

select * from toystore.sales where sales > :h;

[worksofliam]

Here is the plan:

select * from employee where empno = :abc and salary = ?;

bind: 4, 800;

-- [4, 800]
-- select * from employee where empno = ? and salary = ?

bind: select empno, salary from employee limit 5;

-- [1, 500], [2, 600], [3, 700];
-- select * from employee where empno = ? and salary = ?
-- union all
-- select * from employee where empno = ? and salary = ?
-- union alls
-- select * from employee where empno = ? and salary = ?