use DBIx::Abstract;
# get started using existing $DBH handle
my $db = DBIx::Abstract->connect($DBH);

# insert from a hash, auto-quoting along the way
$db->insert('table_name',\%hash_ref);

# update from a hash, auto-quoting for you
$db->update'table_name',\%hash_ref,'item_id = 3');

##</code><code>##

$sth->prepare_cached("SELECT * from t where id = ?");
$DBH->selectall_arrayref($sth, {}, @bind_values);