A lot of what you want is available in Lincoln Stein's Boulder.

Additionally take a look at Alzabo and the DBIx hierarchy on CPAN before commencing your coding to avoid feature duplication.