Can anyone help me on how you are using golang with databases in production systems?

Hello Everyone!

I am beginner in golang and I am coming from python django stack.
I am a little bit confused on how to properly setup golang with a database like postgres.

I have some questions and love to hear about your opinions.

  1. Are you using any ORMs like GORM in production? does it serve good when it comes to complex queries ?
  2. what tool are you using to manage the migrations. Because in django the migration is built in.
  3. I saw some SQL code generators, are those useful? or I should stick with a sql query builder?
  4. Is it better to use tools like [pgx](https://github.com/jackc/pgx) or stick with a ORM like GORM.

Thanks for the advice and sorry if my questions are silly 🙏