Improvement suggestion: Prettier formatting for JSONB_TO_RECORD

[simon-pactum]

When pretty formatting a query with JSONB_TO_RECORD the record definition gets put on one line,
it would be much prettier if it had one field per line, like in SELECT/CREATE TABLE.
This gets especially unreadable when there are lots of fields in the JSONB value:

import sqlglot

sql = """
WITH source(data) AS (
  VALUES
    (
      CAST('{"example_int": 1, "example_text": "foo", "example_float": 1.23, "example_bool": true}' AS JSONB)
    ),
    (
      CAST('{"example_int": 2, "example_text": "bar", "example_float": 4.56, "example_bool": false}' AS JSONB)
    )
)
SELECT
  unpacked.example_int,
  unpacked.example_text,
  unpacked.example_float,
  unpacked.example_bool
FROM
    source,
    JSONB_TO_RECORD(data) AS unpacked(
        example_int INT,
        example_text TEXT,
        example_float DOUBLE PRECISION,
        example_bool BOOLEAN
    )
"""

result, = sqlglot.transpile(sql, read='postgres', write='postgres', pretty=True)
print(result)

Out:

WITH source(data) AS (
  VALUES
    (
      CAST('{"example_int": 1, "example_text": "foo", "example_float": 1.23, "example_bool": true}' AS JSONB)
    ),
    (
      CAST('{"example_int": 2, "example_text": "bar", "example_float": 4.56, "example_bool": false}' AS JSONB)
    )
)
SELECT
  unpacked.example_int,
  unpacked.example_text,
  unpacked.example_float,
  unpacked.example_bool
FROM source, JSONB_TO_RECORD(data) AS unpacked(example_int INT, example_text TEXT, example_float DOUBLE PRECISION, example_bool BOOLEAN)

[tobymao]

thanks for the the issue, but it’s low priority for us. if you’re interested in this feel free to make a PR