multiple label refs to the same col + orm + union

from sqlalchemy import *
from sqlalchemy.orm import *
from sqlalchemy.sql import column

c1 = column('foo')
q = create_session().query(
                        c1.label('f'), 
                        c1.label('b'))

q2 = create_session().query(
                        c1.label('f'), 
                        column('bar').label('b'))

q = q.union_all(q2)
print q.statement



SELECT anon_1.b 
FROM (SELECT foo AS f, foo AS b UNION ALL SELECT foo AS f, bar AS b) AS anon_1

0.6.3 milestone is tentative - this will likely be pushed to 0.6.xx

Comments (2)