ColdFusion's "queryable results cache" is pretty unique.  I don't know of 
any database layers or ORMs that support that functionality out-of-the-box. 
They basically replace the upstream database with the results as a 
"materialized view", and act as the database server for that view.  

There is an official recipe/example for caching results with relations on 
but it doesn't really do what you want.  There may be a 3rd party library 
that does what you want.

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