Hacker News Reader

F# has this + static SQL query string checking at compile time using type providers

"just generates an object type for a given SQL query's result rows"

For a similar purpose in Python I generally use psycopg with namedtuple resultsets; the namedtuple 'records' do what I need for the returned data and are reasonably efficient.

Just hack that for Typescript over this weekend (: https://news.ycombinator.com/item?id=26211286

Wow, that was fast! I'm impressed.

If you want to keep going forward with it, I'd recommend working on making it clearer what the examples do, and looking at sqlc for Go for inspiration. Of the existing versions of this people replied with, that one had the clearest API, or at least clearest explanation on its landing page.

sqlc can do this: https://sqlc.dev/

This is the nicest one of these from the ones posted, I think it's the model to copy.

This!

We don't need ORM, we need OQM (object-query mapping)!