Backend devs , what do you use for database migrations, and what do you wish existed?

Hey folks,

I’ve been experimenting with some new ideas around generating and managing database migrations (mainly Postgres+ MySQL). Before I go deeper, I’m curious how others think about this stuff in real projects.

Which tools or ORMs are you using for migrations today? (Prisma, Sequelize, TypeORM, Knex, Flyway, Liquibase, raw SQL, etc.)

I noticed something interesting:

• Tools like Flyway/Liquibase don’t generate migrations , they only execute them.
• ORMs do generate migrations, but they have quirks. For example:
• 1. - Sequelize sometimes fails to alter certain Postgres types.
• 2. - Prisma drops+recreates a column when you just rename it.
• 3. - Some tools can’t detect complex schema differences at all.

So I’m wondering:

If you could redesign database migrations from scratch
What would you want done differently ?
What’s missing ? What’s painful ? What’s unreliable?

Would love to hear the raw opinions from people who deal with this stuff every day.