The example uses the JSONExtract method to extract filtered results from a table.
The example uses the table(s) created earlier.
/* JSONExtract with filtered results - get the name of everyone older than 23. */ SELECT eno, edata.JSONExtract('$.[?(@.age > 23)].firstName') FROM my_table ORDER BY 1;
Result:
ENO edata.JSONExtract(…) --------------------------- 1 [ "Cameron" ] 2 ? 3 [ "Alex" ] 4 [ "David" ]