JSON Scalar

json_valid()

Arguments & returns

2 overloads

Scalar

Overload link	`col0`	Returns
#01	`JSON`	`BOOLEAN`
#02	`VARCHAR`	`BOOLEAN`

Used in larger rewrites 1

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

SELECT TRY_PARSE_JSON(x)

In DuckDB

SELECT CASE WHEN JSON_VALID(x) THEN CAST(x AS JSON) ELSE NULL END