You actually can do that with SA. See the example here: <a href="http:&#x2F;&#x2F;docs.sqlalchemy.org&#x2F;en&#x2F;latest&#x2F;core&#x2F;tutorial.html#specifying-result-column-behaviors" rel="nofollow">http:&#x2F;&#x2F;docs.sqlalchemy.org&#x2F;en&#x2F;latest&#x2F;core&#x2F;tutorial.html#spec...</a><p>If you specify the columns involved with your text query, then you get back a &#x27;TextAsFrom&#x27; object, and you can apply other transformations to it like .where() or .unique().