I want to do the equivalent of
SELECT * FROM
(SELECT foo, bar FROM baz JOIN quux ON baz.id = quux.id
UNION
SELECT foo, NULL AS bar FROM baz)
GROUP BY (foo, bar) HAVING foo = 'John Doe';
using sqlalchemy 0.6, but I can't seem to sneak that NULL
in there.
This roughly what I have so far:
q1 = session.query(Baz.foo, Quux.bar).join(Quux)
q2 = session.query(Baz.foo, None)
# ^^^^ This breaks!