use SQL::Abstract; my $sa = SQL::Abstract->new; my($sql, @bind) = $sa->insert('YOUR_TABLE', \%value_for_column); $dbhandle->do($sql, {}, @bind);