So, a few dozen days ago I made this:
https://git.sr.ht/~emersion/go-sqlgen
And I'm still wondering whether it's a good idea or not. The upsides are syntax highlighting, strongly typed arguments (not yet implemented). The downside is that the SQL you're using is no longer right next to the Go code.