Resources

JSON Type

duckdb.org

DuckDB supports json via the JSON logical type. For example: SELECT '[1, null, {"key": "value"}]'::JSON; [1, null, {"key": "value"}] Logically, the JSON type is similar to a VARCHAR, but with the restriction that it must be valid JSON. Physically, the data is stored as a VARCHAR. For example, you can't parse invalid JSON: SELECT 'unquoted'::JSON; Conversion Error: Malformed JSON at byte 0 of input: unexpected charac…

Visit Site

Resources duckdb.org