[sqlalchemy] Re: mapping class against arbitrary SQL expression

2009-04-17 Thread King Simon-NFHD78
> -Original Message- > From: sqlalchemy@googlegroups.com > [mailto:sqlalch...@googlegroups.com] On Behalf Of JanW > Sent: 17 April 2009 14:45 > To: sqlalchemy > Subject: [sqlalchemy] Re: mapping class against arbitrary SQL > expression > > > OK, thanks,

[sqlalchemy] Re: mapping class against arbitrary SQL expression

2009-04-17 Thread JanW
OK, thanks, it does work if you make an alias on the select like this: s = select([left.c.car_id, left.c.temperature.label('left_temperature'), right.c.temperature.label('right_temperature')], from_obj=tables, whereclause=and_(left.c.side == 'left',

[sqlalchemy] Re: mapping class against arbitrary SQL expression

2009-04-17 Thread King Simon-NFHD78
> -Original Message- > From: sqlalchemy@googlegroups.com > [mailto:sqlalch...@googlegroups.com] On Behalf Of JanW > Sent: 17 April 2009 13:18 > To: sqlalchemy > Subject: [sqlalchemy] mapping class against arbitrary SQL expression > > > Hi, > > is there a way to map a class against an a