Author here. We kept writing migrations that were fine as a final schema but unsafe during the rollout itself - old pods still reading a column while new pods have already dropped it.

Django solved this ages ago with django-migration-linter, which I leaned on for years on Grafana OnCall.

Drizzle has nothing like it, so we wrote one for our CI. It diffs new migrations against the base branch and fails on drops, renames, and required columns added in one step.

It’s buried in our monorepo right now. There’s an issue linked in the post if you’d want it published to npm.