Thank you for the link. It's really good and detailed.
However, I don't see how executing SQL is easy with Rose::DB::Object. I've read the docs, but the only way I could find was to access the dbh and call DBI methods on it. That breaks the link with the ORM. Is there an other way that I am missing?