I’ll openly admit that we don’t have everything ironed out. In fact my next big project is to tackle derived columns (rename is a column where the transformation is the identity function).
It requires a bit more finesse and integration into our code base as it requires multiple deploys with code that knows how to handle both columns.