What is the DBIx::Class syntax for the CASE WHEN ... THEN SQL syntax?

Does anyone know what's the DBIx::Class equivalent of an SQL query such as:

SELECT cdr_id,
CASE WHEN service_id = 'GPRS' THEN 'KB' WHEN service_id = 'SMS' THEN 'SMS' END AS unit
FROM ...

Thanks

perl dbix-class

Edit Report

0 Answers