Is your feature request related to a problem?

No response

What is the motivation behind your request?

No response

Describe the solution you'd like

Duckdb supports https://duckdb.org/docs/guides/file_formats/json_export.html, including support for JSON line format or ARRAY format.

native export methods are particularly handy since they can stream data too big for RAM, and can easily stream to remote sources like S3 buckets. It would be great to see this included among the other .to_* methods supported by duckdb.

I could take a go at a PR perhaps if you gave me a few pointers? but might be faster to roll this without me.

What version of ibis are you running?

9.5.0

What backend(s) are you using, if any?

DuckDB

Code of Conduct

• I agree to follow this project's Code of Conduct