I am trying to create a property on a mapped class which basically executes a subquery. Here is what I'm trying to do in non-working pseudo code:
mapper(OrderChain, Table('order_chains', self.meta, autoload=True), properties={'entries': relation(OrderChainEntry, order_by=Column('timestamp')), 'first_cancel': select(OrderChainEntry).filter('type'='new').first() }) Is something like this possible? Or what's the best way to approach it? Also, if I've mangled terminology and/or written something that makes no sense, please let me know - I'm very new to this package! Cheers, Andrew -- 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.