If you use Go and PostgreSQL, I’ve been working on a tool to help you “just use SQL” called sqlc[0]. It generates methods and structs for your queries, automatically. It’s made a dramatic difference in my day-to-day workflow.
I really like this! I particularly like that it is oriented around a useful workflow, rather than for just "small code at rest".
It looks like it parses the schema to find type information (2 minute skim, so please forgive me if I got it wrong!) Hoe does it handle schema changes?
[0] https://github.com/kyleconroy/sqlc