[FORMATTING] 11.0.2 commaPositon after doesn't work well when come up with comment end with comma

[MR-BH]

Input data

Which SQL and options did you provide as input?

SELECT
  name, -- user name,
  COUNT(distinct address) -- address 
FROM
  user;

Expected Output

SELECT
  name -- user name,
, COUNT(distinct address) -- address 
FROM
  user;

Actual Output

SELECT
  name, -- user name
, COUNT(distinct address) -- address 
FROM
  user;

Usage

• How are you calling / using the library?
  demo website & ESM
• What SQL language(s) does this apply to?
  {
  language: 'spark',
  commaPosition: 'before',
  }
• Which SQL Formatter version are you using?
  11.0.2

[nene]

Yeah, this is essentially the same bug as #236

The implementation of these features is just very problematic. I've kept them around, though maybe it would be altogether better to just drop these problematic features. For now there's no simple way to properly fix them.

Probably should add a warning to docs to label these as buggy/problematic.

[MR-BH]

I am a little busy right now, I will submit a Merge Request to fix this problem when I have some free time, maybe in December.