> You should tell me how you rename database columns in AWS without breaking anything.

Intermediate updatable views is one way.

forgive my ignorance, but is that AWS (or, cloud) centric?

I thought that was a RDBMS primitive.

Updatable views are a vanilla Postgres feature