oops, didn't mean to submit that quite yet. crazy dog... anyways, given that I have foo_props() which acts as a kind of from- clause as in select * from foo_props( 123);
I'd like to use that in relationship to a Foo class i.e. mapper( Foo, foo_table, properties( props = relationship( FooProps ) ) but of course I can't do a join between Foo and foo_props on foo_id since foo_props takes it as a parameter. I can do a query( FooPropsType ).from_statement( "select * from foo_props( %d )" % foo_id ) but I'm not sure how to set that up as a relationship or column_property. Any hints would be greatly appreciated. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.