Are there any adhoc report builder libraries available in Java/ Groovy ? That generate SQL queries based on dimensions/measures selected [closed]

Question

Ideally the library needs a detailing of what tables/columns/aggregation each dimension/measure map to. Then when given the list of selected ones it generates the SQL querie(s)

Answer 1

Probably what you need is a generic layer to access the underlying analytical database, like OLAP4J which provide API layer to the underlying analytical databases.