v.19.17Improvement

Support Parsing (x,) as Tuple Similar to Python

Support parsing (X,) as tuple similar to python. #7501, #7562 (Amos Bird)
Adds support for parsing single-element tuples written as (X,) similar to Python tuple syntax in ClickHouse queries.

Why it matters

This feature addresses the limitation where ClickHouse did not recognize single-element tuples with a trailing comma. By supporting the (X,) syntax, it enables users to write queries that involve single-element tuples in a way consistent with Python, improving syntax compatibility and reducing confusion.

How to use it

Users can now write single-element tuples using the syntax (X,) in their SQL queries without any additional configuration. For example: SELECT (1,) AS single_tuple; will be correctly parsed as a tuple containing one element.