Relatedly, I'd like to recommend people check out sqlc. It's a Go project, although it does technically support codegen to other languages. https://sqlc.dev/ h

Relatedly, I'd like to recommend people check out sqlc. It's a Go project, although it does technically support codegen to other languages. https://sqlc.dev/ https://sqlc.dev/ With sqlc, you write queries and get fully typed functions you can call. It's not completely perfect, but it's pretty good. As a concept, I think this is great. In practice, I've only been able to use it for Go projects using PostgreSQL so far. Definitely worth it though.