StreamSQL JSON Functions

JSON functions are used for handling JSON data.

TO_JSON - Convert to JSON Function

Syntax: to_json(value)
Description: Converts a value to a JSON string.

FROM_JSON - Parse from JSON Function

Syntax: from_json(json_str)
Description: Parses a value from a JSON string.

JSON_EXTRACT - JSON Extract Function

Syntax: json_extract(json_str, path)
Description: Extracts a value at the specified path from a JSON string.

JSON_VALID - JSON Validation Function

Syntax: json_valid(json_str)
Description: Validates whether a string is valid JSON.

JSON_TYPE - JSON Type Function

Syntax: json_type(json_str)
Description: Returns the type of a JSON value.

JSON_LENGTH - JSON Length Function

Syntax: json_length(json_str)
Description: Returns the length of a JSON array or object.

📚 Related Documentation

• DateTime Functions - Learn detailed usage of datetime functions
• Hash Functions - Learn detailed usage of hash functions
• SQL Reference - View complete SQL syntax reference