This is a self-plug but shapedata.io does similar things on top of Postgres -- it is much younger than Datasette, so has far fewer features, but should give you a similar exploration experience!
I'm keen to check this out, I tried to sign up but got a 403 during the google auth flow.
Along with the message: The developer hasn’t given you access to this app. It’s currently being tested and it hasn’t been verified by Google. If you think you should have access, contact the developer
Will give it a try! Want to use it on top of replicas of our work production DB like in an exploration day setting and see what comes out of it, looks awesome!!
I downloaded and parsed through 100M prices negotiated by Blue Cross of Washington (Premera Blue Cross) for all their in-network healthcare procedures. I've compressed about 5TB of JSON data into much easier to work with tables that you can explore yourself. Excited to hear about what you find!
You should be able to build every SQL query with this. I built an example Top-N query here: https://imgur.com/a/2xKLltl
Right now building Top-N (and my example) assumes you know the rank function exists, but over time it should be easy enough to pre-build "nodes" that do things like this automatically :)