SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE IF NOT EXISTS events (
  `id`        TEXT PRIMARY KEY,
  `timeslots` TEXT
  )
✓
INSERT INTO events (`id`, `timeslots`) VALUES
  ('1',
  '[
     {"start":"2023-01-01","end":"2023-01-02"},
     {"start":"2023-02-02","end":"2023-02-04"}
  ]');
✓
SELECT * FROM events


id
timeslots


1
[
     {"start":"2023-01-01","end":"2023-01-02"},
     {"start":"2023-02-02","end":"2023-02-04"}
  ]


CREATE TABLE timeslots (`id` INTEGER, `start` TEXT, `end` TEXT);
✓
 INSERT INTO timeslots (id, start, end)
        SELECT 
          "1",
          "1",
          "1"
        FROM json_each(NEW.timeslots) AS j;

{
  "code": "SQLITE_ERROR"
}


SELECT * FROM timeslots


id
start
end