This applies to the WHERE clause of a SELECT, UPDATE, or DELETE. Not the data in an UPDATE or INSERT. For UPDATEs, this should work:

my $sql = "UPDATE foo SET bar = ?";
$dbh->do($sql, {}, undef);
[download]

Once the placeholders are substituted, this should be the same as:

UPDATE foo SET bar = NULL;
[download]