Ask HN: Open-Source Query Builder

2 points

2 years ago

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

2 comments