How to write a parametric SQL query?

Question

SQL

Hello.
Can you please tell me how to make a parametric query that opens a dialog with the user?
For example, we have the following query:
select * from Tabl where surname like 'Ivanov%';
how to make it so that instead of the static parameter 'Ivanov%' the request prompts the user to enter this parameter.
There are many implementation options for different programming languages, but the problem is that the query must be compiled in the DbLoader (DbTools) program.

Answer 1

if the program does not provide scripting capabilities (and most likely it does), then nothing.