Easier distant relations via attributes:
models.core_team.all({attributes:[core_team.core_team_users.auth_user.username])
... will automatically join core_team to core_team_users and core_team_users to auth_user.

Note: table/relationship aliases appear to be completely broken.  Can only name aliases in associations with tableName.