Add a generated column over a JSON field

ALTER TABLE events
  ADD COLUMN customer_id INT
    GENERATED ALWAYS AS (payload->>'$.customer_id') STORED,
  ADD INDEX idx_customer (customer_id);