Encapsulate SQL queries and rows in simple perl objectshttp://search.cpan.org/perldoc?DBIx::SearchBuilder
This module provides an object-oriented mechanism for retrieving and updating data in a DBI-accesible database.
In order to use this module, you should create a subclass of DBIx::SearchBuilder and a subclass of DBIx::SearchBuilder::Record for each table that you wish to access. (See the documentation of DBIx::SearchBuilder::Record for more information on subclassing it.)
Your DBIx::SearchBuilder subclass must override NewItem, and probably should override at least _Init also; at the very least, _Init should probably call _Handle and _Table to set the database handle (a DBIx::SearchBuilder::Handle object) and table name for the class. You can try to override just about every other method here, as long as you think you know what you are doing.