GET_JSON_STRING
Extracts a string value from a JSON object by a specified path.
Analyze Syntax
func.get_json_string(get_column(table, 'data'), '$.name')
Analyze Examples
func.get_json_string(get_column(table, 'data'), '$.name')
┌───────┐
│ Alice │
└───────┘
SQL Syntax
GET_JSON_STRING(<data>, '$.name')
SQL Examples
SELECT GET_JSON_STRING('{"name": "Alice"}', '$.name');
┌───────┐
│ Alice │
└───────┘