compare to SQL functions

[mgirlich]

Accessing JSON

json_table(<json>, <path> columns …)
Transforms JSON data into a table. Json_table does not introduce any new functionality but is often simpler (and faster) than using multiple json_value calls.

Creating JSON Data

json_array([<expr>[,…]])
json_array(<query>)
json_arrayagg(<expr> [order by …])
json_objectagg([key] <expr> value <expression>)