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. 


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 < 
> <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. 
> Hope that helps, 
> Simon 

SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See 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 post to this group, send email to
Visit this group at
For more options, visit

Reply via email to