Can SQLAlchemy use the PostgreSQL "only" clause?

Question

I need to use the PostgreSQL clause only in the select query. Can I do this with SQLAlchemy?

Answer 1

You cannot yet.

SQLAlchemy before 0.7.x does not support ONLY [table] syntax, but it will be supported in the upcoming version 0.8.0, see issue 2506 .

The ONLY keyword is implemented as the selected tooltip:

 result = table.select().with_hint(table, 'ONLY', 'postgresql')