Discussion [postgres]: How best to format multi-line `json_build_object`

[joelmukuthu]

Currently

SELECT json_build_object('foo', "foo", 'bar', "bar", 'baz', "baz", 'qux', "qux", 'quux', "quux");

Gets formatted as

SELECT
  json_build_object(
    'foo',
    "foo",
    'bar',
    "bar",
    'baz',
    "baz",
    'qux',
    "qux",
    'quux',
    "quux"
  );

This would be be easier to scan:

SELECT
  json_build_object(
    'foo', "foo",
    'bar', "bar",
    'baz', "baz",
    'qux', "qux",
    'quux', "quux"
  );

And I'd even suggest keeping that formatting style even when the 'foo', "foo" line is longer than 80 characters. Thoughts? :)

[nene]

Yep. Totally! I haven't really done any special formatting for specific functions so far, but json_build_object is definitely the primary candidate for this. The main trouble is that this formatting needs to happen inside the formatting of list_expr, which is a very generic list of comma-separated elements. So one needs to look up in the syntax tree to determine that we're actually inside function argument list. I'm unsure whether that that should be better distinguished at the parser level or are there some utils needed to handle it more easily inside this prettier plugin. For start I'm leaning towards the latter.

…

On Wed, Aug 5, 2026, 12:34 Joel Mukuthu ***@***.***> wrote: *joelmukuthu* created an issue (nene/prettier-plugin-sql-cst#77) <#77> Currently SELECT json_build_object('foo', "foo", 'foo', "foo", 'foo', "foo", 'foo', "foo", 'foo', "foo"); Gets formatted as SELECT json_build_object( 'foo', "foo", 'bar', "bar", 'baz', "baz", 'qux', "qux", 'quux', "quux" ); This would be be easier to scan: SELECT json_build_object( 'foo', "foo", 'bar', "bar", 'baz', "baz", 'qux', "qux", 'quux', "quux" ); And I'd even suggest keeping that formatting style even when the 'foo', "foo" line is longer than 80 characters. Thoughts? :) — Reply to this email directly, view it on GitHub <#77?email_source=notifications&email_token=AAA43ON2HZRHVJNFCH4AMPT5IL5SBA5CNFSL4Z3JMQ5C6L3HNF2C22DVMIXUS43TOVSS6NJQGY4TIOBWGQ2TLJTSMVQXG33OVJZXKYTTMNZGSYTFMSSWK5TFNZ2KYZTPN52GK4S7MNWGSY3L>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAA43OJLEGL5MVDRXUQF2G35IL5SBAVCNFSNUABFKJSXA33TNF2G64TZHM2TQOBWGYZTGMJZHNEXG43VMU5TKMBWHE2DQNRUGU22C5QC> . Triage notifications, keep track of coding agent tasks and review pull requests on the go with GitHub Mobile for iOS <https://github.com/notifications/mobile/ios/AAA43OJF6G44BDARRFRMR535IL5SBA5CNFSL4Z3JMQ5C6L3HNF2C22DVMIXUS43TOVSS6NJQGY4TIOBWGQ2TLJTSMVQXG33OVJZXKYTTMNZGSYTFMSSWK5TFNZ2KUZTPN52GK4S7NFXXG> and Android <https://github.com/notifications/mobile/android/AAA43OJ4HJUXUXVQMHWHYI35IL5SBA5CNFSL4Z3JMQ5C6L3HNF2C22DVMIXUS43TOVSS6NJQGY4TIOBWGQ2TLJTSMVQXG33OVJZXKYTTMNZGSYTFMSSWK5TFNZ2K4ZTPN52GK4S7MFXGI4TPNFSA>. Download it today! You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>