brackt/drizzle/0042_migrate_event_date_to_starts_at.sql

-- Backfill event_starts_at from event_date (midnight UTC) for events
-- that have a date but no explicit start time.
UPDATE "scoring_events"
SET "event_starts_at" = event_date::timestamp AT TIME ZONE 'UTC'
WHERE "event_date" IS NOT NULL
  AND "event_starts_at" IS NULL;