rename a column without disrupting users
Rename the column, add a generated column with the old name.  If inserts or updates of the old column haven't been corrected yet, provide insert and update triggers to handle the new column.  When no logic refers to the old column anymore, drop it.