JSON Scalar

json_value()

Arguments & returns

6 overloads

Scalar

Overload link	`col0`	`col1`	Returns
#01	`JSON`	`BIGINT`	`VARCHAR`
#02	`JSON`	`VARCHAR`	`VARCHAR`
#03	`JSON`	`VARCHAR[]`	`VARCHAR[]`
#04	`VARCHAR`	`BIGINT`	`VARCHAR`
#05	`VARCHAR`	`VARCHAR`	`VARCHAR`
#06	`VARCHAR`	`VARCHAR[]`	`VARCHAR[]`

JSON_VALUE(x, '$.a')

In DuckDB

JSON_VALUE(x, '$.a') ->> '$'