JSON Scalar json_type() Arguments & returns6 overloads json_type(col0) Scalar Overload link col0 Returns #01 JSON →VARCHAR #02 VARCHAR →VARCHAR json_type(col0, col1) Scalar Overload link col0col1 Returns #03 JSONVARCHAR →VARCHAR #04 JSONVARCHAR[] →VARCHAR[] #05 VARCHARVARCHAR →VARCHAR #06 VARCHARVARCHAR[] →VARCHAR[] In other engines Snowflakeis_null_value() IS_NULL_VALUE(x) In Haybarn JSON_TYPE(x) = 'NULL' SQLGlot example ↗ Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3
In Haybarn