http://qs321.pair.com?node_id=728726


in reply to SQL function from DBIC

See the "Arbitrary SQL through a custom ResultSource" section in DBIx::Class::Manual::Cookbook

Also, I think (untested, but appears so from grepping distro) that you can do:
my $dbh = $myobj->db_Main; use Data::Dumper; print Dumper $dbh->selectall_arrayref( 'select enum_range(typename); +', {Slice=>{}}, () );