Hacker News Reader

We’ve been using pg-typed to give us almost the exact thing you are talking about.

While it does have its limitations, its vastly better than raw sql queries.

It looks interesting, but how does it behave with dynamically created queries?

Dynamic queries aren't supported, eg if you want to conditionally join a table or generate where clauses programmatically.