GET_JSON_BOOL
Extracts a boolean value from a JSON object by a specified path.
Analyze Syntax
func.get_json_bool(get_column(table, 'data'), '$.active')
Analyze Examples
func.get_json_bool(get_column(table, 'data'), '$.active')
┌───┐
│ 1 │
└───┘
SQL Syntax
GET_JSON_BOOL(<data>, '$.active')
SQL Examples
SELECT GET_JSON_BOOL('{"active": true}', '$.active');
┌───┐
│ 1 │
└───┘