Seconding sqlx, it's wonderful, is not an ORM and doesn't need code gen.

sqlc is _excellent_ if you are comfortable with its limitations. I love it even though I don't love optional fields query pattern with NULL.