Give Squalor (https://github.com/square/squalor) a shot.

You might find https://github.com/relops/sqlc really nice from an API design point of view (inspird by jOOQ, a Java sql library).

Sqlc is no longer under development, but you can easily use it as a reference to adapt other libraries to have a similar API.

I literally found out about sqlx a few moments before coming here. I was stringing together ~10 columns by hand, and then when i fed them into the `row.Scan()` method, i just about rage quit. On Monday i'm going to try integrating sqlx and see how i like it.

Any other good sql libs i should know about? My coworkers mostly like sql by hand, so no magic ORMs preferably. But unmarshalling rows seems like an absolute requirement.. this is just anarchy without it.

Gorm. Give it a try. Light on magic. Can write by hand easily still. If you arent writing really complex queries and are just shuffling records around Gorm makes life a joy. It is no SQL alchemy but for most SQL users ORM/SRM makes life better. Anyway I think most systems using SQL in business logic end up implementing a relational mapper, just not as well as battle tested mappers. But some use cases do justify avoiding such tools.

Love mux, its super simple and still lets me use the standard library way of making web apps