This blog provides an updated answer.
Quoting from the blog post, this is suggested and worked for me.
>>> from sqlalchemy.dialects import postgresql >>> print str(q.statement.compile(dialect=postgresql.dialect()))
Where q is defined as:
>>> q = DBSession.query(model.Name).distinct(model.Name.value) \ .order_by(model.Name.value)
Or just any kind of session.query().
Thanks to Nicolas Cadou for the answer! I hope it helps others who come searching here.