VARIANT_QUERY
Queries a value from a VARIANT object using a path expression and returns a VARIANT.
Analyze Syntax
func.variant_query(<variant>, <path>)
Analyze Examples
func.variant_query(get_column(table, 'data'), '$.address.city')
┌──────────────┐
│ '"New York"' │
└──────────────┘
SQL Syntax
VARIANT_QUERY(<variant>, <path>)
SQL Examples
SELECT VARIANT_QUERY(data, '$.address.city') FROM events;
┌────────────┐
│ "New York" │
└────────────┘