Feel free to add in your related best practices to solve this in production apps. I post this because in this new project, I have a deployed app whereby people maybe using 24/7. So I cannot find the best time,either at night or on Sundays, to make column changes.
Here is what I do. I have extra maybe 10 “Reserved Columns” which I hide during prototype stage. When i need 1 new column, I rename it and unhide it.
The problem maybe is that the reserved columns are at the end. Maybe if we regenerate,then move the new column to the right position and then regenerate, maybe it will be seemless? I need to find out and repost here.