You can maintain all the code in git or dev ops. You can allow automatic schema changes/mutation till bronze layer. Any schema changes or migrations in Silver/Gold need to be managed via CI CD with an approver. With features such as column mapping mode most of the changes is direct.