Add compression options to COPY TO #6286
Description
What type of enhancement is this?
User experience
What does the enhancement do?
Allow for CSV or JSON exports to be compressed. As DuckDB does, I suggest implementing at least zstd and gzip. I personally would use zstd.
Implementation challenges
No response