AryaWu/sqlite

1.mode qbox2.timer on3.param set $label 'q87'4SELECT rowid, x->>$label FROM data1 WHERE x->>$label IS NOT NULL;5 6CREATE TEMP TABLE t2(x JSON TEXT);7WITH RECURSIVE8  c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<25000),9  array1(y) AS (10    SELECT json_group_array(11             json_object('x',x,'y',random(),'z',hex(randomblob(50)))12           )13      FROM c14  ),15  c2(n) AS (VALUES(1) UNION ALL SELECT n+1 FROM c2 WHERE n<5)16INSERT INTO t2(x)17  SELECT jsonb_object('a',n,'b',n*2,'c',y,'d',3,'e',5,'f',6) FROM array1, c2;18CREATE INDEX t2x1 ON t2(x->>'a');19CREATE INDEX t2x2 ON t2(x->>'b');20CREATE INDEX t2x3 ON t2(x->>'e');21CREATE INDEX t2x4 ON t2(x->>'f');22UPDATE t2 SET x=jsonb_replace(x,'$.f',(x->>'f')+1);23UPDATE t2 SET x=jsonb_set(x,'$.e',(x->>'f')-1);24UPDATE t2 SET x=jsonb_remove(x,'$.d');25