All functions > JSON
All functions in the JSON category.
| Function | DuckDB | Trino | Serving | Description |
|---|---|---|---|---|
JSON_PARSE() | ✓ | ✓ | ✓ | Returns the given string as a JSON expression. |
TRY_JSON_PARSE() | ✓ | ✓ | ✓ | Returns the given string as a JSON expression, or NULL if the string is not valid JSON. |
JSON_PARSE_AS() | ✓ | ✓ | ✓ | Returns the value of a JSON expression represented as a string in the given type. |
JSON_EXTRACT() | ✓ | ✓ | ✓ | Returns the value of the given JSON path in the given JSON expression. |
JSON_EXTRACT_SCALAR() | ✓ | ✓ | ✓ | Returns the scalar value of the given JSON path in the given JSON expression. |
JSON_FORMAT() | ✓ | ✓ | ✓ | Returns the given JSON expression as a string. |
JSON_ARRAY_COUNT() | ✓ | ✓ | ✗ | Returns the number of elements in a JSON array. |
JSON_KEYS() | ✓ | ✓ | ✓ | Returns the keys of a JSON object as an array of strings. |
JSON_TYPE() | ✓ | ✓ | ✗ | Returns the type of a JSON value as a string. |
Summary
Functions in this category: 9
This documentation is automatically generated from the FeatureMesh registry.