Re: [sqlalchemy] How to Query.selecting_from(subquery).join()

2011-10-13 Thread Michael Bayer
hi Daniele - You're in luck because I saw you ask this on IRC yesterday. Using a non-mapped selectable as the "thing to select from" in Query wasn't supported, but I considered this a bug which has been fixed: http://www.sqlalchemy.org/trac/ticket/2298 If you get the latest tip at http://hg.

[sqlalchemy] How to Query.selecting_from(subquery).join()

2011-10-13 Thread Daniele
What is the proper way to use a subquery as the FROM clause, while being able to use the Query.join() method? Here is an example of what I mean: http://pastebin.com/RUktuZZm The docs at http://www.sqlalchemy.org/docs/orm/query.html#sqlalchemy.orm.query.Query.subquery state: "Eager JOIN generatio