You might also want to check out chromatic’s perl.com article DBI is Okay.

Generalised INSERT and UPDATE functions are very common stuff.

Addendum: While I'm personally not fond of much of the DBIx CPAN namespace, there are many modules dealing with this and more ‘programmatic’ alternatives to dealing directly with SQL.