Re: [sqlalchemy] Collections and outer joins with core

2013-10-11 Thread Michael Bayer
On Oct 11, 2013, at 1:25 PM, Gustavo Baratto wrote: > - is it possible to know which columns in the result of a join belong to each > of the tables? > > sure: for row in result: cols_from_table_a = [row[col] for col in tablea.c] cols_from_table_b = [row[col] for col in tableb.c] >

[sqlalchemy] Collections and outer joins with core

2013-10-11 Thread Gustavo Baratto
Hello there, I'm looking into the cheapest way of, in core, building collections into each row on fairly large left and right tables (the collections themselves are small though). By collection i mean the same thing as in sqlalchemy orm: an outer left join, that to each row of the left table with