Allow for `CREATE TABLE AS SELECT` statements

[angelamayxie]

Currently, the query create table t2 as select * from t generates an error message ERROR: TableCopier only accepts CreateTable or TableNode as the destination, despite it being a valid a query in Postgres (at least according to ChatGPT)

Discovered in dolthub/go-mysql-server#3110. Test currently tagged with Dialect: "mysql". Remove dialect tag once fixed