# ClientFlow v4928.1.5.127.1 — CONFIRM_DELIVERY cleanup SQL hotfix

## Correction

Fixes `scripts/disable_automatic_confirm_delivery.py --apply` on PostgreSQL.

The cleanup used unqualified `done_at` and `metadata` expressions inside an
`UPDATE tasks ... FROM opportunities`, where both tables expose similarly named
columns. PostgreSQL therefore raised `AmbiguousColumn` and rolled back the
transaction.

The hotfix qualifies the task-side expressions as:

- `COALESCE(t.done_at, now())`
- `COALESCE(t.metadata, '{}'::jsonb)`

## Safety

- Dry-run behavior is unchanged.
- Manual delivery checks remain preserved.
- No customer communication is sent.
- The failed pre-hotfix execution made no data changes because the transaction
  was rolled back.
- The v127 runtime behavior and `CONFIRM_DELIVERY_AUTOMATION_ENABLED=false`
  configuration are unchanged.

## Validation

- Python compilation passed for the corrected script.
- Static regression assertions verify both qualified column references.
