JSON Scalar json_array_length() Reference: DuckDB 2.0.0 Arguments & returns6 overloads json_array_length(json) Scalar Overload link json Returns #01 JSON โUBIGINT #02 VARCHAR โUBIGINT json_array_length(json, path) Scalar Overload link jsonpath Returns #03 JSONVARCHAR โUBIGINT #04 JSONVARCHAR[] โUBIGINT[] #05 VARCHARVARCHAR โUBIGINT #06 VARCHARVARCHAR[] โUBIGINT[] Available in Haybarn 2.0 Haybarn 1.5 DuckDB 2.0 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3