copy: support binary format

**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);`

```sql
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: https://github.com/cockroachdb/cockroach/issues/103543 and https://github.com/cockroachdb/cockroach/issues/103544

This is CockroachDB 23.1.1

Jira issue: CRDB-28069