JSON Macro

json()

Arguments & returns

Macro

Overload link	`x`	Returns
#01	`unknown`	`unknown`

json_extract(x, '$')

SELECT INT64(JSON_QUERY(JSON '{"key": 2000}', '$.key'))

In DuckDB

SELECT CAST(JSON('{"key": 2000}') -> '$.key' AS BIGINT)

SELECT PARSE_JSON('{"fruit":"banana"}'):fruit

In DuckDB

SELECT JSON('{"fruit":"banana"}') -> '$.fruit'

Used in larger rewrites 1

These examples use json as one part of a larger SQL translation.

JSON_FORMAT(JSON '"x"')

In DuckDB

CAST(TO_JSON(JSON('"x"')) AS TEXT)