Fabric Warehouse - Deployment Pipeline - Fix ALTER TABLE issue

Currently, when adding a column to a Warehouse table in Dev workspace, and then using Fabric Deployment Pipeline to deploy the Warehouse to Test and Prod workspace, the existing table gets dropped and recreated with the added column.

Unfortunately, this leads to all existing data in the table in Test and Prod getting lost.

Please fix this issue.

I believe this issue is documented here:

Currently, if you use ALTER TABLE to add a constraint or column in the database project, the table will be dropped and recreated when deploying, resulting in data loss.

https://learn.microsoft.com/en-us/fabric/data-warehouse/source-control#limitations-for-deployment-pipelines