In Oracle, I can write a query like this: SELECT ... FROM ... WHERE id IN (SELECT f_id FROM f ('param')) to constrain the returned rows to those that have an id in the set returned by the table function f.
I would like to generate such a query with sqlalchemy like this: q = session.query (...)....filter (id.in_ (sq)) but I cannot figure out how to define sq. I've tried something like this: sq = session.query ('F_ID').from_statement ('SELECT column_value FROM TABLE (f (:p1))').params(p1 = 'param') but I get: TypeError: 'Annotated_TextClause' object is not iterable Any suggestions? Thanks. Rodney --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---