Is your feature request related to a problem or challenge?

@tinfoil-knight added backwards compatibility to the COPY command format options in version 37.0.0 via #9744

So now this format is supported (similar to duckdb)

COPY (select * from (values (1))) to 'test_files/scratch/copy/'
OPTIONS (format json, compression gzip);

However, the newer more consistent syntax looks like

COPY (select * from (values (1))) to 'test_files/scratch/copy/'
STORED AS JSON
OPTIONS (compression gzip);

@metesynnada asked #9753 (review) if we should phase out the old (format json) syntax

Describe the solution you'd like

Decide if filing this ticket to discuss

Describe alternatives you've considered

No response

Additional context

No response