I would like to generate this query: SELECT a.pk, aa.response FROM attendee as "a" JOIN field as "f" on f.conference_pk = a.conference_pk LEFT JOIN attendee_answer as "aa" ON aa.field_pk = f.pk AND aa.attendee_pk = a.pk;
Using the ORM, I came up with: onclause = and_( AttendeeAnswer.field_pk==Field.pk, AttendeeAnswer.attendee_pk == Attendee.pk ) query = self.session.query(Attendee).join( Field, Field.conference_pk == Attendee.conference_pk ).outerjoin( (AttendeeAnswer, onclause) ).add_entity( AttendeeAnswer ).filter( Attendee.conference_pk == conference_pk ) results = query.all() But this returns separate ORM objects, but in this specific case I would just like the results in a list containing the data results, rather than individual ORM objects. Is there a way to do this or should I just pass my select statement to execute? -- 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.