v.22.8Improvement
Support for CREATE TEMPORARY TABLE with column lists
Support queries CREATE TEMPORARY TABLE ... (<list of columns>) AS .... #39462 (Kruglov Pavel).Why it matters
This feature allows users to define temporary tables with explicit column definitions based on the result of a query, improving control over the table schema during temporary table creation and simplifying workflows that require temporary data staging with precise column structures.How to use it
To use this feature, execute a query with the syntax:CREATE TEMPORARY TABLE table_name (column1 DataType1, column2 DataType2, ...) AS <query>This creates a temporary table with the specified columns and populates it with data from the given query.