Yes, thanks. It's not really what I want but I understand. I'm porting a few old Coldfusion web apps and CF has a neat query object, if you query at data base, you are returned a query object. which you can show the results etc. but you can also run new queries on that query object. For example you may have a very large query, which you can then cache. Then you can run additional queries on that cache query to filter the results.
Thanks, Charles On Friday, February 9, 2018 at 3:41:26 AM UTC-8, Simon King wrote: > > On Fri, Feb 9, 2018 at 6:06 AM, Charles Heizer <ceh...@gmail.com > <javascript:>> wrote: > > Hello, does anyone know if it's possible to query a query result in > > SQLAlchemy? > > > > Thanks! > > > > I'm not quite sure what you mean. If you've got a Query object with > some filter conditions already defined, you can add further > restrictions to it simply by calling its ".filter()" method. > Alternatively you can convert the query to a subquery and then build > another query around that. > > http://docs.sqlalchemy.org/en/latest/orm/tutorial.html#using-subqueries > > Hope that helps, > > Simon > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.