I’m looking for a suggestion similar to Jooq (https://www.jooq.org/) That connects to a live DB and generates model files based on the live database schema.
I was looking at SQLBoiler though it seems like it has issues with working with multiple Postgres Schemas.
Has anyone found any good tool they like and would recommend?
Try https://github.com/avelino/awesome-go. The topic ORM has about 21 different options I guess. And if you need anything else that’s the best curated list of Go projects I’ve found so far.
If you are interested, take a look at my project https://fs02.github.io/rel/
The aim wasn’t to be query builder, but it does have that feature built in.
it looks nice, the doc is polished which is always a selling point for an OSS project.
I was looking specifically for something that can introspect a live database and build its query objects from the database schema. I don’t think you have that feature.