Creating sql queries for reports in java

Question

I want to create a parametrized query to receive something from the database. This query is big, that big that it is not really possible to put it in a @Query annotation in a CrudRepository and also it should be very flexible so that depending on parameters it may add a join or a with segment to the query. The way I saw this situation being handled was building the query in a String variable and then passing that string to a JdbcTemplate or being executed in another ways. Something like that:

String sql = getWith(params) + getJoin(params) + getWhere(params);

These methods can get very big and ugly. Is there a way I can achieve my goal more elegantly?

question from:https://stackoverflow.com/questions/65940754/creating-sql-queries-for-reports-in-java

Answer 1

Waitting for answers