Unified syntax for renaming table value constructor

Detail name	Value
Changelog Number	11242
Type	Improvement
Status	Resolved
Fix Versions	Exasol 7.1.0
Resolution Date	2021-08-03

Background

There are different areas in SQL that allow renaming e.g. Table in JOIN, column name, subselect, etc. The renaming can be done with or without "AS" and with or without renaming the columns (depending on the context).

Improvement

Table value constructor now can now be used with or without "AS" syntax for renaming or completely without renaming the columns.

Examples
All these renamings are now valid syntax.

select * from SYS.EXA_ALL_COLUMNS;
select * from SYS.EXA_ALL_COLUMNS T;
select * from SYS.EXA_ALL_COLUMNS as T;

create table T as values (1) V(V1);
create table T as values (1) as V(V1);

select * from values (1);
select * from values (1) V;
select * from values (1) as V; 
select * from values (1) V(V1);
select * from values (1) as V(V1);