From the DBI man page synopsis:

$rv  = $dbh->do($statement, \%attr, @bind_values);
[download]

If you're going to be doing just a single insert, 'do' might be best. If you're going to be doing several, it'd be best to 'prepare' your insert statement and 'execute' it with your bind values for each row you're adding. Typical DBI considerations.