Apply Settings from CREATE ... AS SELECT Queries (Fixes #28810)

Why it matters

This feature addresses the issue where settings specified in CREATE ... AS SELECT queries were not applied as expected. It ensures that any settings given in the creation query are properly passed and applied, improving consistency and user control over table creation behavior.

How to use it

Specify the desired settings directly in the CREATE TABLE ... AS SELECT query using the standard syntax for settings. These settings will now be automatically applied during the table creation process, without requiring additional manual configuration.