End all ongoing quarantines at the end of March

[atoncetti]

SELECT SET_CONFIG('versioning.originator_id', '', true);
SELECT SET_CONFIG('versioning.origin', 'migration', true);
UPDATE
  cases update_case
  SET
      phases = ARRAY_REPLACE(
          update_case.phases,
          replace_case.search_phase,
          replace_case.replace_phase
      )
  FROM (
    SELECT
	    cases.uuid AS case_uuid,
      active_phases AS search_phase,
      active_phases || JSONB_BUILD_OBJECT(
        'end',
        '2022-04-01',
        'start',
        LEAST(
          (active_phases ->> 'start')::date,
          '2022-04-01'::date
        ),
        'send_automated_close_email',
        TO_JSON(FALSE)
      ) AS replace_phase
    FROM cases
    JOIN
      UNNEST(cases.phases) AS active_phases
      ON
        (active_phases -> 'details' ->> '__type__' = 'index') AND 
        (active_phases ->> 'quarantine_order')::boolean AND
        (active_phases ->> 'end')::date > ('2022-04-01')::date
  ) AS replace_case
  WHERE replace_case.case_uuid = update_case.uuid
  RETURNING 
    case_uuid,
    replace_case.search_phase as original_phases;

Assumes that there are no phases set to start and end in the future.