[sqlalchemy] SA 0.3.11 producing wrong code for func.any()

[Andreas Jung]

Hi,

running SA 0.3.11 against PG 7.4.

A SA query like

session.query(Node).query(func.any(Node.c.tools=='1234')

produces the following SQL code:

select ....  from node where
where any(node.tools) = '1234'.

However Postgres does not support this syntax and complains
with a syntax error. Postgres requires:

...where '1234' = any(node.tools).

Is there a workaround to get the syntax right through configuration?

Andreas

pgp38fYgWnK0u.pgp
Description: PGP signature