> most companies now are doing Agile development ... you have this situation where the schema is continually evolving week by week

I haven't seen that level of churn in any of the agile places that I have worked and it is not an inevitable consequence of agile working. If you don't want schema churn, then don't do that.