[Dbix-class] Need SQL => DBIC translator

[Aran Deltac]

My brain hurts.  I'm trying to write this:

SELECT COUNT(*)
FROM lang.translations tf
LEFT JOIN lang.translations tt
ON (tf.customer_group_id=tt.customer_group_id AND
tf.message_code=tt.message_code)
WHERE tt.customer_group_id=0
AND tf.language_code="en"
AND tt.language_code="fr"
AND (tt.translation=tt.message_code OR tt.translation=tf.translation);

In SQL::Abstract/DBIC syntax.
Would someone give me an idea of what I could do here?

Thanks,

Aran