Json_query()
Description
FUNCTION: json_query(<json>[, <query-type>[, <path>]])
Queries a JSON value. The query type determines what information is returned. Supported query types are: type, size, exists, get, keys, and values.
Paths use SQLite JSON path syntax (e.g., $.key for object members, $[0] for array elements).
Examples
> say json_query({“name”:“Bob”}, get, $.name)
You say, “Bob”
> say json_query([1,2,3], size)
You say, “3”
> say json_query({“a”:1,“b”:2}, keys)
You say, “a b”
> say json_query({“name”:“Bob”}, type, $.name)
You say, “string”