v.22.8New Feature
Add New Pretty Format Options for Output
Add formatsPrettyMonoBlock,PrettyNoEscapesMonoBlock,PrettyCompactNoEscapes,PrettyCompactNoEscapesMonoBlock,PrettySpaceNoEscapes,PrettySpaceMonoBlock,PrettySpaceNoEscapesMonoBlock. #39646 (Kruglov Pavel).
Why it matters
These new formats enhance the readability and customization of query output in the ClickHouse client or when fetching results. They provide variations of pretty formats that differ by whitespace usage, escaping behavior, and block structuring, allowing users to choose the output style that best fits their needs for displaying or processing query results.How to use it
Specify the desired output format in the query options or client settings using theFORMAT clause. For example, to use the PrettyMonoBlock format, append FORMAT PrettyMonoBlock to your query. Choose among the new formats depending on your preference for escape characters, spacing, and block layout.