DataMapper ORM v1.8.0

[eluser]Robert Liljedahl[/eluser]
I'm stuck on howto make a query.
I got groups, permissions and modules. I'm working on the update-function in the groups-controller.
I want to list all the modules and show if the group do in fact have access to the module in question.

It's easy for me to get all modules. It's also easy for me to get all permissions for a certain group.
The question is how I combine these two into on query for DataMapper.

This is how I'd do it with a 'normal' query:

Code:

SELECT modules.*, permissions.id AS 'permission_id'
  FROM modules
    LEFT OUTER JOIN permissions
      ON (permissions.module_id = modules.id AND permissions.group_id = 4)
  GROUP BY modules.id