Changelog category (leave one):

• Improvement

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):

Improved the display of tuples in Pretty format to show elements as subcolumns, preserving the hierarchy in the header for better readability. Closes #65388.

Documentation entry for user-facing changes

Motivation: The new output format for tuples in Pretty formats improves the readability of query results by displaying tuple elements as subcolumns with clear headers, making it easier for users to interpret complex nested structures.

Example usage :

SELECT 'hello' AS x, (1 AS a, 'world' AS b) AS t

                  ┌─x─────┬─t───────────┐
Previous result : │ hello │ (1,'world') │
                  └───────┴─────────────┘

      ┌─x─────┬─t─────────┐
      ├───────┼─a─┬─b─────┤
Now : │ hello │ 1 │ world │
      └───────┴───┴───────┘