SQLAlchemy equivalent to Django x.objects.extra ()?

Question

I just found out about the django (model) .objects.extra () function as described: http://docs.djangoproject.com/en/1.2/ref/models/querysets/#extra

I hope sqlalchemy has something similar. I would like to have the flexibility of raw sql through the cursor, but still my results are returned via ORM.

Can you force the SQL code into your query? (By the way, I use a declarative database)

Thanks in advance

Answer 1

I think you are looking for Query.from_statement: http://www.sqlalchemy.org/docs/orm/query.html#sqlalchemy.orm.query.Query.from_statement