Support COPY TO COMPRESSION option

[carlopi]

What happens?

COPY (SELECT 32) TO 'a' (COMPRESSION GZIP);
COPY (SELECT 32) TO 'b' (COMPRESSION ZSTD);
COPY (SELECT 32) TO 'c' (COMPRESSION NONE);

Generate identical files (all uncompressed).

Reported on https://discord.com/channels/909674491309850675/921100929984503858/1200888663257665606

To Reproduce

See above

Browser/Environment:

any

Device:

any

DuckDB-Wasm Version:

1.28-dev106

DuckDB-Wasm Deployment:

shell.duckdb.org / any

Full Name:

Carlo Piovesan

Affiliation:

DuckDB Labs

[carlopi]

Most likely some duckdb::VirtualFileSystem problem (= has to be instantiated?).
Probably connected to reading from '.csv.gz' files like

FROM 'https://raw.githubusercontent.com/duckdb/duckdb/main/data/csv/ips.csv.gz';
Invalid Input Error: Error in file "https://raw.githubusercontent.com/duckdb/duckdb/main/data/csv/ips.csv.gz": CSV options could not be auto-detected. Consider setting parser options manually.

(while it's working on CLI correctly)

[carlopi]

It might also be related to: duckdb/duckdb#10275

[carlopi]

Solved via #2002