[rockwotj]

I do like this approach in theory, but agreed I don't think that the devex has been solved and I don't know how many people would value a different approach as SQL feels like king in many places... FWIW it's kind of the approach that IndexedDB in the web takes, however that the API is quite bad IMO.

Or maybe there is a higher level DSL that you could apply to create query plans (something like MongoDB aggregation pipelines maybe?), but it quickly becomes basically the same as SQL.

[mike_hearn]

The author doesn't know it, but he's asking for Permazen - exactly what you're asking for:

https://github.com/permazen/permazen/blob/master/README.md

It's a bit like the record layer in FoundationDB but more advanced. You specify query plans manually, so you can't accidentally forget an index for example.

[osigurdson]

>> SQL feels like king in many places

I think it is because most people can make something work with SQL.