You know, I've been toying with this very idea in my head for a while, as a way to make safe schema migrations. But I also know very little about databases so had no idea if this was a stupid idea or not. Glad to know I'm not alone.
One issue I've considered is fk relationships - that could get complicated depending on the approach.
One issue I've considered is fk relationships - that could get complicated depending on the approach.