Allow Column Specification in CREATE TABLE AS table_function Query

Why it matters

This feature addresses issues where users could not define a custom column list when creating a table from a table function. It enables more precise schema control and fixes related problems reported in issues #9249 and #14214.

How to use it

When using CREATE TABLE with AS table_function(...), specify the desired columns explicitly by providing a column list after the table name, for example:

CREATE TABLE my_table (col1 Int32, col2 String) AS some_table_function(...)