No, there is nothing special about the way perl is handling it. "with" is a reserved word in mysql, as shown here. The solution is to surround "with" with backticks (`) as described here. Thus your query would become something like:

my $sth = $dbh->prepare("insert into blah (...,`with`) values(?,?)");
...
[download]