We love go-jet! We are now using it or migrating it to, in all our projects.
This is simply the best go SQL builder we have tried so far.
It is type safe thanks to the code generation and the query result mapping is very powerful.
As far as we know, this is the only solution that fully supports mapping of LEFT OUTER JOIN
out of the box.
We have used straight sql package, sqlx, squirrel
with and without sqlx
, and more recently sqlboiler.
The latter is an ORM rather than an SQL builder but we love the type safety with code generation.
Also their null types package is a breeze to work with.
But over time, sqlboiler
being an ORM, showed its limitations in terms of performance and flexibility.