v.25.10Improvement

JSON columns are now pretty printed

JSON columns are now pretty printed when using Vertical format. Closes #81794. #88524 (Frank Rosner).
ClickHouse now supports pretty printing of JSON columns when using the Vertical output format.

Why it matters

This feature improves the readability of JSON data when displayed in the Vertical format by formatting JSON columns in an indented and structured way, making it easier for users to interpret complex JSON output directly in query results.

How to use it

To use this feature, simply select the Vertical output format in your ClickHouse client or query interface. JSON columns will automatically be pretty printed without any additional configuration. For example:

SELECT * FROM your_table FORMAT Vertical