Make outputformat one line configurable

[snuyanzin]

Currently to setup csv outputformat it is required to specify up to 3 different properties, in case of table up to 2, e.g.

!set outputformat csv
!set csvDelimiter ###
!set csvQuoteCharacter !

or

!set outputformat table
!set maxColumnWidth 123

There is a bit more convenient way to use one line only like for instance sqlcl does.
In case of sqlline it could be

!outputformat csv ### !

which internally could be translated to

!set outputformat csv
!set csvDelimiter ###
!set csvQuoteCharacter !

As there is already existing command !outputformat which translates to !set outputformat the suggestion is to allow having several arguments for this command with translation to set to several properties

[julianhyde]

Seems like a good idea. Can you add some documentation?

If you specify 'outputformat csv' without the extra arguments, are the other properties set to their default values, or are they left as is?

[snuyanzin]

They will be left as is. To have them set with default values it's required to specify it explicitly like

!outputformat csv default default
# or if only one is required to be default
!outputformat csv default !
!outputformat csv ### default

Agree, I will also add some docs about it.

[julianhyde]

Fixed in d0ae1d1, PR #299. Thanks @snuyanzin!