Rose::DB::Object is looking good to me these days. It can handle pretty complex queries and lets you use SQL if you need to. It also appears to be much faster than the others on a benchmark written by the author. I haven't used it in production code yet though.
A ditto there from me. Rose::DB::Object looks to me to be the best of the newer generation of ORM systems, and I'm going to be trying it in production as soon as I get an opportunity.