[Dbix-class] How do I use stored Procedures in where-clause?

[Moritz Onken]

Hi,

i want to use a statement with the MD5-function in the where clause.

Like
SELECT * from table where password = MD5('secret')

DBIx::Class::Manual::Cookbook had no answer on that.