When I was first starting out writing applications it was very common for the DBA in charge of a database to require all writes to go to a stored procedure and

When I was first starting out writing applications it was very common for the DBA in charge of a database to require all writes to go to a stored procedure and all reads to go through views. It was at times onerous but it made migrations like these a snap. With most migrations/rdms it could even be atomic.