How to setup a reviewing migration (and rollback) gate for scripts in Azure DevOps?

Maybe this is should not bee asked here but I´m doing it because of the work that seems to be going into management of deployment with things like [bundles ](https://github.com/dotnet/efcore/issues/19693), [Improve experience for managing migrations](https://github.com/dotnet/efcore/issues/22945) and [Improve experience deploying databases created by Migrations](https://github.com/dotnet/efcore/issues/19587) so here goes. If you feel strongly against it just close it and I´ll ask it there.

My question is, **how can I gate/review migration and rollback scripts in DevOps?**

The out of the box functionality to review SQL changes with using AzureDevOps is lacking a lot. And also how can I automatically create rollback files for "thisMigration" agains "lastMigration"?

I managed to get a ["poor mans version"](https://stackoverflow.com/questions/69706120/gated-ef-migrations-for-sql-scripts-in-azure-devops) working but I think this is something that is not going to cut it.

And maybe this will not get better and we need to move to something like Octopus Deploy?

Looking forward hearing your input.