I have a requirement where I need to build query dynamically i.e., which columns to select, from which tables and which joins to use.
Is there any existing library that I can use?
I have already looked into Spring Projections but it doesn't serve the purpose. It requires projection (interface) needed to be defined before hand.
I am also looking at JOOQ. It looks like it may serve the purpose but before I dig into this, I wanted to see if there is anything built into Spring or there are any other better option?
P.S: I need queries for Azure SQL Dialect