Generally if you take the always append columns never drop or rename existing ones you’ll be okay. (Then once everyone moves over to the new stuff you can drop or otherwise cleanup the table).

Make alter table statements, depending on the engine some can be non-locking/blocking.

Deploy code.

Enjoy.