hpcc-systems/HPCC-Platform — pull request #2442 by rpastrana (2012-05-31 21:47:05+00:00)
Title: Gh 2417 sql aliasing

gh-2417-sql_aliasing support for sql aliasing

Functions use alias as ECL attribute name therefore aliases for
function calls cannot be ECL keywords
FieldMetadata.getlabel returns alias if one present

HPCC JDBC - add support for column/table aliasing -

SQL Alias Syntax for Tables:

SELECT column_name(s)
FROM table_name
AS alias_name

SQL Alias Syntax for Columns:
SELECT column_name AS alias_name
FROM table_name

Alias Example

SELECT po.OrderID, p.LastName, p.FirstName
FROM Persons AS p,
Product_Orders AS po
WHERE p.LastName='Hansen' AND p.FirstName='Ola'