BEGIN; TRUNCATE TABLE session_cache; ALTER TABLE orders ADD COLUMN metadata JSONB DEFAULT '{}'::jsonb; UPDATE orders SET metadata = jsonb_build_object('legacy', true) WHERE created_at < '2023-01-01'; COMMIT;