Use Goose for migrations, place them in a separate folder and run migrations with goose up

For SQL in the production environment it's better to avoid full-blown ORM and just use sqlx.