File Level Deployment (especially Warehouse and Fabric SQL) for Fabric Deployment Pipelines

Fabric deployment pipelines currently support deploying items in their entirety. The announcements from Barcelona introduced file-level commit for Git, supporting more granular controls for source control of larger items like warehouses and databases.

For organizations that want simpler approaches to CI/CD, it would be helpful to have file-level deployment as an option. For SQL-based items like warehouses and databases, it would be similar to the Schema Compare capabilities in Visual Studio, where you can pick specific objects in the item, identify dependencies, and have a publish script to review detailing how the deployment will be done.