no-rename-column

What It Detects

Renaming a column breaks all running application queries that reference the old name.

Why It's Dangerous

Column renames take effect immediately. Any in-flight query or application code referencing the old column name will fail. Use the expand-contract pattern with a new column instead.

Bad Example

ALTER TABLE users RENAME COLUMN name TO full_name;

Good Example

-- Add new column, backfill, update app code, drop old
ALTER TABLE users ADD COLUMN full_name TEXT;
UPDATE users SET full_name = name;

Configuration

Disable this rule:

# .migrationpilotrc.yml
rules:
  MP010: false

Or change its severity:

# .migrationpilotrc.yml
rules:
  MP010:
    severity: warning