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