creator-hub/internal/environment/migrations/012_task_recovery_compatibility.sql

UPDATE operation_task
SET hold_reason = 'task_result_uncertain', updated_at = now()
WHERE state = 'needs_confirmation'
  AND hold_reason = 'legacy_confirmation_required';