By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t1 (id INTEGER PRIMARY KEY, json TEXT);
✓
CREATE TRIGGER t1_after_insert AFTER INSERT ON t1 FOR EACH ROW
BEGIN
UPDATE t1
SET json = json(NEW.json)
WHERE t1.id = NEW.id;
END;
✓
INSERT INTO t1 (json) VALUES (' { "this" : "is", "a": [ "test" ] } ')
{ "code": "SQLITE_ERROR" }
SELECT * FROM t1;
| id | json |
|---|