#You may well note from my code below that my use of DBIx::Class is through the Catalyst framework.
# The code below fails with a very long stack trace which basically says that my SQL syntax is wrong.

            $c->model('DB::Users')->search(
              { role => 'friend' },
               {
                  join => { 'user_roles' =>  'roles'  },
                  '+select' => [ 'user_roles.role_id', 'roles.role' ],
                  '+as'     => [ 'roleid', 'role' ],
               },
               { rows => 10 }
            );