in reply to Conditions as named columns using DBIx::Class
Create and save a view with the calculated column you need.