I agree that too much abstraction from your SQL database is a world of frustration. I feel that ‘query builders’ themselves can end up feeling like too much abs

I agree that too much abstraction from your SQL database is a world of frustration. I feel that ‘query builders’ themselves can end up feeling like too much abstraction, albeit of a slightly different kind. I’ve written about an alternative approach for TypeScript [1] and am in the process of turning it into an npm module (complete with nested queries that produce LATERAL joins, with all results fully typed). [1] https://github.com/jawj/mostly-ormless/blob/lateral/README.md https://github.com/jawj/mostly-ormless/blob/lateral/README.m... (note: I’ve updated the code and write-up here, but not yet the instructions for setting it up, so YMMV on that)