The DevOps release add-on has no option to set the Drift Handling argument when using the "Deploy database changes from a release artifact" operation. There is an option to specify the Drift Filtering when creating the release artifact but no option to control what happens when deploying, which seems a bit pointless.

This became an issue some point in May 2024, the default Drift Handling seems to have changed from 'RevertAndDeploy' to 'Ignore' meaning the drift won't be reverted without rewriting the pipeline task to use PowerShell - defeating the point of the add-on.

Apparently this is a feature request, not a bug!!