The Prisma Migrate team is thinking about these issues. I'll let them elaborate when they wake up tomorrow :-)

We are taking inspiration from this great writeup on how Github has implemented a workflow that enable their developers to collaborate on Schema Migrations at scale: https://github.blog/2020-02-14-automating-mysql-schema-migra...