sqlc always seemed like a really neat concept to me. I love the idea of being able to write my queries as raw SQL in separate files, would make everything so much more interoperable with other tools. Having your queries defined as strings inside some other programming language always struck me as not so awesome.
I'd love to see something like this for Typescript and Effect's SQL integration with schemas.
SQL is barely parametrizable, so, in my opinion, the DX is much worse than using a query builder and not much better than simply using strings.
You just have to duplicate things a bit more, but with the help of LLMs building the queries is very simple and extending them even easier
https://github.com/adelsz/pgtyped