Proposal: SQLMesh materialize to branches

[ravenac95]

What is it?

While sqlmesh is itself not a destructive process for the datawarehouse. It could be interesting to experiment with using nessie's branches to maintain a "fast rollback" capability. This means we would materialize everything into the branched iceberg tables and then "merge to main" as we need to. This would allow us to recover in case of a disastrous run. This is in addition to relying on the virtual tables that sqlmesh already gives us to test different changes.

[linear]

OSO-483 Proposal: SQLMesh materialize to branches