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.<p>I'm surprised that this doesn't exist as many SaaS want to provide self-serve analytics to their users.<p>I've found 2 react query builder libraries but they don't support aggregation at all [1] [2].<p>Did I miss something? Any reason why this doesn't exist? If we built this open-source, would you use it?<p>[1] https://github.com/react-querybuilder/react-querybuilder
[2] https://github.com/ukrbublik/react-awesome-query-builder
Maintainer of `react-querybuilder` here. Couple of things:<p>Firstly, both RQB and RAQB facilitate the `WHERE` clause of a query, not the `SELECT`, `FROM`, or other clauses that would control aggregation.<p>Secondly, I would strongly discourage you from passing SQL from the client to the server, even if you parameterize it. For RQB, we recommend passing the native query object as JSON to your API and using our provided export method on the server to transform it into SQL (or whatever format you need).<p>Once in a blue moon I get requests for aggregation support in RQB, so to address your last question: yes, I think there would be some demand for something like that.