I haven't tried it but it looks like Xata has come up with a neat solution to DB migrations (at least for postgres). There can be two versions of the app running.

https://xata.io/blog/multi-version-schema-migrations