Post

SQLite matches an expression index only on the expression as written. With an index on json_extract(body, '$.email'), WHERE body ->> '$.email' = ? scanned the whole table on 3.54.1; the json_extract form used the index.