SWQL Alias reuse

codebender

Enhance SWQL statements to allow reuse of aliases in the preceding SELECTION.

Examples:

SELECT A
             , A * B AS AB
             , B
             , B / A AS BA
             , AB + BA AS ABBA
FROM TABLE;

SELECT N.IPAddress AS IP
     , N.DnsBackward NAME
     , CHARINDEX('.',IP,1)-1 AS P1
     , CHARINDEX('.',IP,P1)-1 AS P2
     , CHARINDEX('.',IP,P2)-1 AS P3
     , CHARINDEX('.',IP,P3)-1 AS P4
FROM IPAM.IPNode AS N;