In a schema file from mysql I have a generated field like so: id VARCHAR(64) GENERATED ALWAYS AS (myjson->"$.id") STORED I'm trying to port this to sqlite3 and can't seem to figure out how to do it. I tried using json_extract(myjson, "$.id") but json_extract only seems to work in a SELECT statement. Would appreciate any ideas / pointers. Thanks!