[KhalPanda]

I've enjoyed using https://github.com/kyleconroy/sqlc on a couple of projects. Give it your schema and queries, get type-safe interfaces in return. It's a happy medium for me between all-in ORM and raw SQL.

[tdeck]

Another option is something like jOOQ https://www.jooq.org/ which provides typed query-builders for writing SQL expressions.