What happens?

The SQL to/from JSON docs describe the json_deserialize_sql function as

Deserialize one or many json serialized statements back to an equivalent SQL string.

When deserializing many json serialized statements a ParserException is raised. Given the description in the documentation I was expecting one or many statements to be deserialized back into the equivalent SQL string.

To Reproduce

SELECT json_deserialize_sql(json_serialize_sql('SELECT 1;SELECT 2'));

Parser Error:
Error parsing json: more than one statement

OS:

Darwin 23.5.0 arm64

DuckDB Version:

v1.3.0 (Ossivalis) 71c5c07 clang-16.0.0

DuckDB Client:

CLI

Hardware:

No response

Full Name:

Evan Duncan

Affiliation:

Greenhouse Software

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a stable release

Did you include all relevant data sets for reproducing the issue?

Not applicable - the reproduction does not require a data set

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

• Yes, I have