v.22.2New Feature
Add table function format(format_name, data)
Add table function format(format_name, data). #34125 (Kruglov Pavel).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 callingformat(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.