feature request : set output format from file extension

[kpym]

I know that we can specify the output format with -f flag, but if we run

 csvq -o "test.json" 'select * from `test.csv`'

the resulting test.json file is in text format not in json, as the default output format is always text. It will be nice if the default format depends on the specified output :

• if file is specified (-o option is used) then the extension can be used to set it;
• if the output is piped, the csv format should be used (as I already requested in #71).

Thanks for your work on this fantastic tool 🙏

[mithrandie]

In version 1.17.1, when the --format option is not specified, the file specified by the --out option will be output in a specific format if it has the following extensions.

file extension	format
.csv	CSV
.tsv	TSV
.json	JSON
.jsonl	JSON Lines
.ltsv	LTSV
.md	GFM
.org	ORG

[ktzanev]

Thanks for considering my request !