Specify Column Names in Insert/Create Statement

[woshiniuren]

Hi ~
"insert into aaa(de00001) select name from a;" for this sql string expect to be .aaa.de00001<- .a.name
but it turns out to be .aaa.name <- .a.name, is this something wrong ?

[reata]

To specify column name in the query is not supported yet. The following also doesn't work:

create table tab1 (col1 string) AS
select col2 from tab2;

create view tab1 (col1, col2) AS
select col3, col4 from tab2;

I'll see what I can do to improve on this.

[nickhuang1996]

@reata Sure! Thank you for your explanation!

[reata]

This is supported by ansi dialect. Note we won't port it back to default non-validating as sqlparse cannot generate correct AST for this case.