> Nobody has ever needed to rollback.

I did a rollback several times, but not a DB schema rollback. The potential to lose data is too big. I try to write code and migrations that support rolling back at least one deployment without rolling back the migration. Most of the time you need this anyway to support zero downtime deployments.

Writing and testing backward migrations is ... problematic.