Support for Create Table Using Another Table

[rmorais01]

Is your feature request related to a problem? Please describe.
A very useful addition to the simple-ddl-parser would be the ability to parse and process the SQL Create Table Using Another Table. Currently there is support only for the Create command, and hence this feature will extend the functionality of this DDL parser.

Describe the solution you'd like
The solution must be able to parse the SQL CREATE command and create the table structure by referencing the table in the select statement which must exist in the same file. The new table gets the same column definitions.

Describe alternatives you've considered
NA

Additional context
Here are some examples for the Create Table Using Another Table command
Syntax
CREATE TABLE new_table_name AS
SELECT column1, column2,...
FROM existing_table_name
WHERE ....;

Example
CREATE TABLE Person (
person_id int,
last_name varchar(255),
first_name varchar(255),
address varchar(255),
city varchar(255)
);

CREATE TABLE TestTable AS
SELECT person_id, first_name, last_name
FROM Person;

[dmaresma]

It's quite difficult it's require a db connection to derive SQL Select statement INTO a valid table definition and project the metadata with sp_help_text or get_ddl functions. the module doesn't include a database engine for derivation you are looking for.

[xnuinside]

@dmaresma I think idea was if create table exists in same ddl script. In that case it is possible.

[xnuinside]

https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html - we have support for 'LIKE' and 'CLONE' statements. I don't like idea to add SELECT - because it is part of DML, not DDL, but I will think about it, maybe add support only for this case