I'm working on a tool that compiles SQL queries into type-safe code. It's called sqlc and it already works really well: https://sqlc.dev

Go and PostgreSQL are currently supported, with Kotlin and MySQL support on the way.

https://github.com/kyleconroy/sqlc