> -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,
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',
> -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