When our auto migration code fails, for example due to:

1. Column type changes - we'll need to drop and add the columns to fix this (Postgres does this already, other destinations fail)
2. Adding primary keys for new columns (that don't have existing data) - we'll need to drop the table to fix this
3. For the case of removing PKs we've added a detailed message (for Postgres) - we need to either drop the column or just the not null constraint to fix this