the easiest way to do this would be to issue the SQL yourself...below uses the object_session() and object_mapper() functions to ensure that the current connection, if any, is used (you could also just say myengine.execute() if that didnt matter):
class MyClass(object): @property def someprop(self): return object_session(self).\ execute(select([MyClass.somecol]).where(MyClass.id==self.id), \ mapper=object_mapper(self)).scalar() --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---