Support for column aliases

[GoogleCodeExporter]

Currently we can't create select's with column aliases, like in

SELECT 
  p1.name as son, 
  p2.name as dad 
FROM
  PEOPLE p1,
  PEOPLE p2
WHERE
  p1.parentId = p2.id

Column aliases are useful when using the same table multiple times. 

The attached file is a patch to SelectQuery for supporting Column aliases.

Actually, aliases are supported on all kind of Selectables, which will only 
cause a problem when someone tries to alias the WildCardColumn. Empty aliases 
will also create broken queries.

Original issue reported on code.google.com by brunoabdon on 6 Aug 2010 at 4:39

Attachments:

• columnAliases.patch