[web2py] CASE statements in DAL?

[Harkirat]

Hi All !
          I am new to web2py and my company is building an enterprise
level web application that will run on the desktop and also mobile
apps using web2py! So far it has been a gr8 experience working with
web2py and kudos to all the developers that made such an awesome
framework !

I am trying to write some queries in the DAL that require a CASE
statement e.g.
SELECT CASE WHEN 1=1 THEN 0 ELSE 1 END

Is there a way to write this in the DAL?

Thanks in advance for your help!

Harkirat