Feature Request: Format `jsonb_build_object` as `key, value`

[tordans]

Describe the Feature

When writing JSONB, the standard formatting looks like this…

For me it is a lot easier to read when the key and values share line, like

jsonb_build_object('category', 'intersection_corner', 'size', 5) AS tags,
-- or
  jsonb_build_object(
    'size',
    ((tags ->> 'width')::float / 2)::float,
    'category',
    'driveway',
    'highway',
    tags ->> 'highway',
    'road',
    tags ->> 'road',
    'width',
    tags ->> 'width'
  ) AS tags,

  jsonb_build_object(
    /* sql-formatter-disable */
    'category', 'intersection_corner',
    'size', 5
    /* sql-formatter-enable */
  ) AS tags,
-- and
  jsonb_build_object(
    /* sql-formatter-disable */
    'size', ((tags ->> 'width')::float / 2)::float,
    'category', 'driveway',
    'highway', tags ->> 'highway',
    'road', tags ->> 'road',
    'width', tags ->> 'width'
    /* sql-formatter-enable */
  ) AS tags,

Why do you want this feature?

JSON always uses a key: value pattern to show it's data.
It would be a lot easier for me quickly parse the SQL if the formatter use a similar pattern (even though the jsonb_build_object lists all keys and values in one big list…)

[nene]

This would be nice, but it's unlikely to happen in SQL Formatter. Partly because it's hard to implement with current architecture of SQL Formatter, and partly because it's not a high-priority thing to fix.

There's more of a chance for such a feature to be implemented in prettier-plugin-sql-cst.

Also slightly related to nene/sql-parser-cst#84