That is what dbt solves. Version your SQL and continuously rehydrate the data to match the most recent models.