Why do you believe that Perl (or DBI) is telling you a lie?

You have an error in your SQL syntax sounds very convincing to me. Is the string you pass to DBI valid SQL?

Most likely, you want to read about DBI placeholders and use these instead of interpolating data directly into your SQL strings. See also http://bobby-tables.com.