How to store SQL queries in an Autotests project?

Question

Java

In an Autotest project, you often need to add queries to test the database. It is inconvenient to support such requests in classes, because they have a volume with a large number of lines. The project uses Java + JDBC to work with the database. So far I'm storing each request in separate files, but I'm not sure if this is the right approach.

How do you store SQL queries?

Answer 1

So we keep. In text form. For variable fields, we use placeholders, which we replace with the desired values