But what happens when schema Xn adds a column N, and schema Xn+1 removes it? The base schema, the source for all the views will contain all the columns Xn... from all the migrations until purged.
That purging is what has a lot of operational complexity. And renaming a column. All the rest is zero-downtime in PG already.
That purging is what has a lot of operational complexity. And renaming a column. All the rest is zero-downtime in PG already.