JSON Extract

-- Drill 24 — استخراج حقول JSON بـ json_extract — SQLite 3.38+
CREATE TABLE events (
  id INTEGER PRIMARY KEY,
  payload TEXT NOT NULL
);

INSERT INTO events (payload)
VALUES ('{"kind":"lesson_view","course":"sql","minutes":12}');

SELECT
  json_extract(payload, '$.kind') AS event_kind,
  json_extract(payload, '$.course') AS course
FROM events;