VARIANT_GET
Extracts a typed value from a VARIANT object at a specified path.
Analyze Syntax
func.variant_get(<variant>, <path>, <type>)
Analyze Examples
func.variant_get(get_column(table, 'data'), '$.name', 'STRING')
┌─────────┐
│ 'Alice' │
└─────────┘
SQL Syntax
VARIANT_GET(<variant>, <path>, <type>)
SQL Examples
SELECT VARIANT_GET(data, '$.name', 'STRING') FROM events;
┌───────┐
│ Alice │
└───────┘