Even if you write the database objects yourself from scratch, it's still worth doing, to isolate that code from the rest of your program. You may actually want to try writing it from scratch once, just to see what's involved.

In most cases you can mix your own hand-written SQL with these modules. You'll find that Rose::DB::Object provides the ability to do almost any SQL you need without resorting to that though.