Experimental Support for CREATE TABLE AS SELECT in MaterializedMySQL

Why it matters

This feature enables users to create new tables in MaterializedMySQL using <code>CREATE TABLE ... AS SELECT</code>, allowing for easier and more flexible table creation by copying structure and data from existing tables. It simplifies and enhances the usability of the MaterializedMySQL engine by supporting this common SQL pattern.

How to use it

To use this feature, create a new table in MaterializedMySQL with the syntax:

CREATE TABLE <table_name> AS SELECT <columns> FROM <source_table>;

This will create a new table based on the structure and content of the selected data from an existing table within the MaterializedMySQL engine. Note that this feature is experimental.