Example using the json1 extension:<p>BEGIN TRANSACTION;<p>CREATE TABLE json_tbl(id integer primary key, json text collate nocase);
CREATE VIEW json_tbl_view AS 
	SELECT id, json_extract(json, &#x27;$.value&#x27;) AS val 
	FROM json_tbl;<p>CREATE INDEX json_tbl_idx on json_tbl(json_extract(json, &#x27;$.value&#x27;));<p>EXPLAIN QUERY PLAN SELECT * FROM json_tbl_view WHERE &#x27;the_value_33&#x27; = val;<p>COMMIT;