Editor for compiling SQL queries in code?

Question

SQL

I do SQL queries in code like this. At the beginning I write the request in the editor. If it works, then I copy it into the code and replace the values ​​in the query with variables.
However, if there are a lot of brackets and variables, then you get a real hell with brackets and quotes.
Question. Maybe there is an easier way, or some kind of tool, so that I can simply substitute the necessary variables in the request and insert it into the code?

Answer 1

sql parameters binding
and in your case I think it's worth looking towards which ORM...

Answer 2

https://stackoverflow.com/questions/9772036/pass-a...