How to store and get sql queries from .properties file?

Question

Java

How to store and get sql queries from .properties file?
Only this comes to mind))

sql.properties file
user.get.all=select * from user

@PropertySource("classpath:sql.properties")
...
@Autowired
private Environment env;
...
String sql = env.getProperty("user.get.all");

Answer 1

Sql queries, most likely, do not exist on their own, but are associated with some kind of model and business logic.
The model is in your code and the business logic is in the code, which means that the queries should be in the code.