Add Support for Multi-Word Data Type Names for SQL Compatibility

Why it matters

This feature enables ClickHouse to recognize and process data types consisting of multiple words, aligning its syntax closer to standard SQL dialects. It solves the problem of incompatibility when using common SQL data types that are naturally expressed as multiple words, making migrations and interoperability easier for users.

How to use it

Users can now write and use multi-word data type names directly in their table definitions and queries, for example:

CREATE TABLE example (
    column1 DOUBLE PRECISION,
    column2 CHAR VARYING(255)
)

without any additional configuration.