JSON Functions ​

This section covers functions that operate on JSON strings and compose objects and arrays.

Prerequisites: ​

To create a JSONB type column and use the new JSON functions (JSON_EXTRACT and JSON_TYPEOF), you must enable them by setting the enable_full_json configuration parameter.

To use the lateral join for JSON (FLATTEN), you must enable it by setting the enable_full_funcscan and enable_full_lateral_join configuration parameters. This feature is currently in beta.