Perl has several first rate ORMs/DB-kits on the CPAN. All of which will be better than anything you will be be able to write by yourself. Unless you are a DB/DBD/DBI expert, or doing exploration for fun or learning exercises, writing your own ORM is a big mistake.

• DBIx::Class.
• Rose::DB.
• Fey.
• KiokuDB.
• Pixie.
• Tangram.
• Even SQL::Abstract for pure plain, LCD features.

Fey and KiokuDB are the most natively Moosey. Update: "natively Moosey" isn't an endorsement for "best." Also Rose::HTML::Objects makes the full Rose suite the closest match for the 3 tasks you listed. Template or Mason or any of a few other template kits would serve fine with any of the ORMs too.