[sqlalchemy] Adding columns to SELECT clause without having to filter result entities

I have an association object pattern between Person and Item through PersonItem. Item is subclassed using single-table inheritance into FooItem and BarItem, with a column named 'foo' on FooItem (although it's obviously on the same shared table as BarItem). I'd like to query PersonItem and

Re: [sqlalchemy] Adding columns to SELECT clause without having to filter result entities

On Aug 9, 2010, at 10:56 AM, Nikolaj wrote: I have an association object pattern between Person and Item through PersonItem. Item is subclassed using single-table inheritance into FooItem and BarItem, with a column named 'foo' on FooItem (although it's obviously on the same shared table as