Support for any() and all()

[Former user]

SQLAlchemy support the "in" operator in where clauses. Since Python 2.5 now has "any()" and "all()" functions for iterators, it would be nice if they existed in SQLAlchemy, too. They are used in PostgreSQL, for example: http://www.postgresql.org/docs/8.1/interactive/functions-comparisons.html

Also, I just noticed on http://www.sqlalchemy.org/docs/sqlconstruction.myt#sql_whereclause_operators, the sentence "Boolean operators include not_(), and() and or(), ...". Unfortunately, HTML generation has swallowed the underscores after and_ and or_, interpreting it as italics.

[Mike Bayer]

id rather not add ANY/ALL to the core since these are not standard SQL operators. you can do (and ive seen people use):

   func.any(...)
   func.all(...)

etc.

fixed the doc formatting thing in the trunk and on the site.