Show HN: TypeScript SQL Query API Engine for Postgres
github.comSome 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).
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.
I've also built a small playground where you can see the raw SQL queries that are created when you run the API [2]
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!
[1]: https://github.com/gajus/slonik
[2]: https://sql-api-playground.netlify.app/ This is genius... very awesome. sql-api-engine would be an insanely powerful tool for business apps, I really hope you keep working at this! I really appreciate slonik for e2e data integrity across the stack backed by zod at every step. It has many advantages over other tools in the ecosystem. I'd love to see your PoC examples. Poking around the sql-api-engine codebase there's much to appreciate and respect. Great work!