Something I worked on previously seems to have gone down a similar path ..
at the time I was producing loads of O-O cgi-form-dbi solutions, and they were beginning to look & feel the same.
The solution : the ObjectCreate.pm module -> point it at a MySQL db $x, with tables $y & $z, and it'd write
$x.pm $x::$y.pm & $x::$z.pm .. containting the necessary object code for the 4 sql actions.

It hasn't been released, and isn't really in a state where I'd be happy todo so -
many outstanding issues akin to the ones you mentioned above.
It did however execute 90% of the typing for me (:

Maybe not the most elegant solution, but it made perl-contracting a joy to finish 1 months 'work time' in a coupla hours (:
the 'qif;