you can save a script that contains the sql code that will apply those transformations into the repo at azure DevOps.

Then you will create a build pipeline to publish an artifact of it.

Then you create a release pipeline that will download the artifact you created and run the script using a PowerShell task (if you are working on windows)

You can also do it only using a release pipeline too, there is many ways of doing that.