Hand-writing SQL is always a good way to go. But if you want something for simple CRUD, I’ve used gorm and it does make CRUD a breeze. And it also makes scanning into structs easy. Chi is a great option for routing.
It sounds like you have a good idea of what you’re using to build your project. Build it and ask more specific questions when you have them!