I'm looking for a frontend library that would take a database schema as input, and then provide a visual query builder like Metabase that supports filtering and aggregation. The output would be SQL that I would then send to the server to get data and render charts/tables.
I'm surprised that this doesn't exist as many SaaS want to provide self-serve analytics to their users.
I've found 2 react query builder libraries but they don't support aggregation at all [1] [2].
Did I miss something? Any reason why this doesn't exist? If we built this open-source, would you use it?
[1] https://github.com/react-querybuilder/react-querybuilder
[2] https://github.com/ukrbublik/react-awesome-query-builder