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
Original issue reported on code.google.com by
brunoabdon
on 6 Aug 2010 at 4:39Attachments: