[sqlalchemy] Re: Two enhancement proposals for orm.Query

2009-06-18 Thread Adrian von Bidder
On Wednesday 17 June 2009 19.08:10 klaus wrote: ... whether a query will yield any result ... The best approximation seems to be query.first() is not None which can select a lot of columns. I often see query.count() 0 which can become quite expensive on a DBMS like PostgreSQL.

[sqlalchemy] Re: Two enhancement proposals for orm.Query

2009-06-17 Thread Michael Bayer
On Jun 17, 1:08 pm, klaus klaus.barthelm...@haufe.de wrote: not to technicalities in the data model. Would it be difficult to make something like     session.query(B).join(ref, backward=True) work? kw arguments per join condition aren't really an option to join() since join() is designed