v.22.2New Feature

Add table function format(format_name, data)

Add table function format(format_name, data). #34125 (Kruglov Pavel).
Introduces the table function format(format_name, data) to ClickHouse.

Why it matters

This feature allows users to output data in various formats directly from queries by specifying the desired format, improving flexibility in data representation and integration with other systems.

How to use it

Use the table function by calling format(format_name, data) in your query, where format_name is the name of the output format (e.g., CSV, JSON) and data is the dataset or subquery to be formatted.