>    SELECT person.id, person.name from person, person_role, role
>     where
>       person.id = person_role.person_id   and
>       role.id = person_role.role_id       and
>       role.name='editor';

somewhat inefficient:
[p for p in Person.select() if [r for r in p.roles if r.name == 'editor']]