Oops, I may have spoken too soon about things working... The children relationship works fine and generates the correct query.
However, I don't think that the parent backref relationship is generating the right query. item0.parent produces the following where clause: ... WHERE ? = item.parent_uuid ? => item0.uuid -------------------------------------------------------- and I think it should be: WHERE ? = item.uuid ? => item0.parent_uuid --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---