I’ve built a similar solution around BigQuery. I used temporary tables to let user iterate over the data instead of writing huge analytics queries.

I would open source it if I had decent experience with OSS.

If anyone with OSS maintainer experience wants to help with that - ping me.