[Dbix-class] select sum count group by conversion?

[Ulrich Leodolter]

Hi, 

i wrote a simple personal training diary,
actually i convert my perl CGI DBI script to Catalyst DBIx::Class.

what is the best way to convert sql querys like this:

SELECT YEAR( datum ) jahr, SUM( km ) summe_km, COUNT( km ) anzahl, 
SUM( time_to_sec( dauer ) ) summe_dauer, SUM( hm ) summe_hm FROM data
WHERE 1 GROUP  BY jahr';

i it possible without literal sql ?