Make Schema Inference Work for CREATE AS SELECT

Why it matters

This feature addresses the lack of automatic schema inference when creating tables using the CREATE TABLE AS SELECT syntax. It simplifies table creation by automatically deriving the schema from the SELECT query, eliminating the need for manual column specification and reducing errors.

How to use it

Use the standard CREATE TABLE <table_name> AS SELECT syntax to create a new table. ClickHouse will automatically infer the schema from the SELECT statement without requiring explicit column definitions.