Databases suck for this, but don't forget "restore from backup" can be a viable rollback option.

Apart from that you can do stupid SRE tricks like copying tables around in-memory before schema changes.