I just downloaded the 4.2 version and didn't import my settings from previous. I'm trying to setup the formatter to produce similar results to what I got in 4.1.5 but it seems to be doing a worse job of formatting the query. I have provided a example query below with a desired and actual results. In the actual results I have almost all line breaks off except before comma, but the formatted result breaks NVL or DECODE. Additionally the formatter indents 4 spaces after the comma. I would like it not to, and can't find a setting to achieve this.
--unformatted
SELECT nvl('this','that') col_name, 'Column1', 'Col2' FROM dual;
--desired format
--NVL, DECODES on one line
--break before comma, no space after.
--align columns and KEYWORDS
SELECT nvl('this', 'that') col_name
,'Column1'
,'Col2'
FROM dual;
--SD 4.2 actual format
-- break before comma. everything else unchecked.
SELECT nvl(
'this'
,'that'
) col_name
, 'Column1'
, 'Col2'
FROM dual;