[Dbix-class] Retrieving join table info from many_to_many

[Paul Makepeace]

I have two tables of things, user and widget. I have a join table
user_widget and have set up the DBIC bits so I can say @widgets =
$user->widgets(). Now, for each of @widgets I actually want a piece of
info in user_widgets, color (i.e. each user can customize the
appearance of their widget).

Is there any way to get that (ideally prefetched) color from the join
table, given a $bar? Or do I have to get a list of the join table
entries prefetching widget and then iterate over that?

 I'm aiming for, e.g.,

  my @widgets :Stashed = $user->widgets;

  [% FOREACH widget = widgets %]
   <td>[% widget.name %] has color [% widget.[magic here?].color %]</td>
  [% END %]

Thanks,
Paul