oh, just realised I had forgottoen to mention how to make use of the actual Moose Role in the end but of course that's trivial once your result class (MyApp::Schema::Result::Foo) is a proper Moose class:

...
extends 'DBIx::Class::Core'; 
with "FoomakerRole";
...
[download]