View model - named attributes in mapping statement are not automatically mapped to the corresponding column in the table definition

Unexpected sequential dependency between virtual table column order and mapping column sequence.

The TEIID statement to create a virtual table goes like:

CREATE VIEW TargetModelViewName (
ColumnA … 1
ColumnB … 2
ColumnC …) … 3
AS SELECT
SourceModel.SourceTable.ColX AS ColumnA, 1
SourceModel.SourceTable.ColY AS ColumnB, 2
SourceModel.SourceTable.ColZ AS ColumnC; 3

In any 4th+ generation query language a positional dependency is not expected, and therefore the following statement should also work, but fails in the TEIID

CREATE VIEW TargetModelViewName (
ColumnA … 1
ColumnB … 2
ColumnC …) … 3
AS SELECT
SourceModel.SourceTable.ColX AS ColumnA, 1
SourceModel.SourceTable.ColZ AS ColumnC, 3
SourceModel.SourceTable.ColY AS ColumnB; 2