(aside: one thing that bugs me about the various ORM solutions is that they want to handle their own db connections and want me to provide DSNs instead of $dbhs. with CDBI this is relatively easy to get around by overriding My::CDBI->db_Main(). is it that easy with RDBO or DBIC?)
With L<DBIx::Class::Schema> you can do this quite simply:
#... setup schema stuff here ...
# Do whatever you want to do to build your $dbh
|We're not surrounded, we're in a target-rich environment!|