How to tell IDE to ignore SQL syntax error

Created November 28, 2011 20:47

I have an SQL query that's being partially built by PHP, and the PHP-provided parts are inserted into the query via string variables. However, because the part being inserted by PHP is more than just a simple value (which the SQL parser handles okay), the resulting SQL string is not valid until runtime, and it's being marked as containing syntax errors. Here's a nicely contrived example:

$setClause = '`bar` = 3';

$sql = "INSERT INTO Foo SET $setClause";

This ends up with a red squiggle at the closing quote, and the inspection pop-up reports:

'=' expected, unexpected end of file

Since such errors propagate around in rather obvious fashion (big red bar on the side, file name in tab red-underlined, containing folder names in project red-underlined, etc.), I'd really like to supress it (but in general keep the in-your-face nature of such errors enabled, as I want that behavior elsewhere). However, I can't figure out how. My first thought was to simply uninject the SQL, but choosing that command appears to have no effect. How can I tell PhpStorm to not worry about this one error?