Ever since I discovered sqlc it's my go to for any dB it supports.
It's a joy to work with and does exactly what you expect it to, no strange magic.