Inspired by the query language of EdgeDB and GraphQL, I created a npm package that can generate sql query from a more concise syntax.<p>Some key features:<p>* select with nested syntax and auto generate join-table statements<p>* auto add table name to each column<p>It comes with a "typescript-playground-style" online demo so you can try it without any setup ;)
I like it!<p>One problem you will run into is putting a LIMIT on relationship queries<p>You can't use a limit for this<p><pre><code> select post [
id
title
# Can't generate simple LIMIT here
user { nickname } limit 2
]
limit 5</code></pre>