Class::DBI can basically do what you're asking for. See this article.