_memory

Custom SQL query returning 9 rows (hide)

explain select json_extract('{"foo": "bar", "bar": "baz"}', '$.foo', '$.bar') as bits

This data as json, testall, testnone, testresponse, CSV

addropcodep1p2p3p4p5comment
0 Init 0 1 0   0  
1 Once 0 6 0   0  
2 String8 0 3 0 {"foo": "bar", "bar": "baz"} 0  
3 String8 0 4 0 $.foo 0  
4 String8 0 5 0 $.bar 0  
5 Function 7 3 2 json_extract(-1) 0  
6 Copy 2 1 0   0  
7 ResultRow 1 1 0   0  
8 Halt 0 0 0   0