Adding a new column sounds simple. In practice, it can cascade into downtime, broken queries, and hours of fixes if handled without care. The right approach depends on your database, data volume, and tolerance for risk.
In PostgreSQL, ALTER TABLE ADD COLUMN is straightforward when adding nullable or default-null fields.