Usually, I do use DBI.

I use this for when I have to run sql scripts that I have no control over. The scripts can get a little involved, for instance creating temp tables to build the result sets and declaring variables. Basically- stuff that should be done in a stored proc, but isn't.