You might want to look into the various ORMs (Object Relational Models) such as Class::DBI, DBIx::Class and friends.