v.20.7New Feature

Function formatRow Added for String Formatting of SQL Outputs

Official CH changelog text
A function formatRow is added to support turning arbitrary expressions into a string via given format. It's useful for manipulating SQL outputs and is quite versatile combined with the columns function. #12574 (Amos Bird).
Introduces the formatRow function to convert arbitrary expressions into formatted strings, enhancing SQL output manipulation.

Why it matters

The formatRow function solves the problem of dynamically formatting SQL query results into customized string representations. It adds versatility when combined with the columns function, enabling more flexible and readable output formatting for users.

How to use it

Use the formatRow function in your SQL queries by passing expressions and a format string to generate formatted result strings. It can be seamlessly combined with the columns function for dynamic output formatting. For example:

SELECT formatRow(columns(), '{0} - {1}') FROM ...

Related resources

PreviousNext