http://www.perlmonks.org?node_id=316709


in reply to How to call MySQL's PASSWORD() from Class::DBI?

You are looking for "Ima::DBI queries" section of the manual for Class::DBI. Specifically: set_sql() function. Additionally, you can read the manual for Ima::DBI - that should increase your understanding, if need be. :)

Basically, you just do a set_sql() with SQL that you need, using placeholders, Class::DBI creates a function for you to use, and you call it with parameters. Nice and easy.