copy: support binary format

[dbist]

Is your feature request related to a problem? Please describe.
Testing DuckDB Postgres connector which relies on libpq and which translates queries to COPY (SELECT *) TO STDOUT (FORMAT binary);

COPY (SELECT * FROM test LIMIT 5) TO STDOUT (FORMAT binary);  
ERROR: unimplemented: binary format for COPY TO not implemented
SQLSTATE: 0A000
HINT: You have attempted to use a feature that is not yet implemented.
See: https://go.crdb.dev/issue-v/97180/v23.1

Describe the solution you'd like
Support the binary format

Describe alternatives you've considered
Unfortunately DuckDB does not support FORMAT text or csv today.

Additional context
Add any other context or screenshots about the feature request here.

Related issues: #103543 and #103544

This is CockroachDB 23.1.1

Jira issue: CRDB-28069