Some time ago I started working on this query API engine, a sort of layer on top of slonik[1], to abstract the most tedious parts of using straight SQL (dynamic filtering, paginating etc).<p>The idea was to make it easy to create typesafe querying APIs, similar to ORMs I was using at the time, but using pure SQL. I was also inspired by hasura's GraphQL API engine, but wanted to build something simpler for tRPC APIs, thus the name.<p>I've also built a small playground where you can see the raw SQL queries that are created when you run the API [2]<p>It's a proof of concept that I've used to build APIs with a lot of dynamic filters and complex sub-queries, I'd love to know your thoughts on it!<p>[1]: <a href="https://github.com/gajus/slonik">https://github.com/gajus/slonik</a><p>[2]: <a href="https://sql-api-playground.netlify.app/" rel="nofollow">https://sql-api-playground.netlify.app/</a>