Avoid syntax error warnings when using string interpolation in SQL query generation

Question

When using string interpolation, sprintf or generally any form of dynamically creating an SQL query string, PhpStorm usually trips up. For example:

$placeholders = join(', ', array_fill(0, count($ids), '?'));
$stmt = $db->prepare("SELECT * FROM foo WHERE bar IN ($placeholders)");
$stmt->execute($ids);

or:

$db->prepare(sprintf('INSERT .. (%s) ..', $foo))

These understandably trigger some sort of SQL syntax error warning in PhpStorm. Is there any way to suppress those without outright disabling SQL language parsing?

Answer 1

I found the definitive answer to this problem from Jetbrains Blog:

http://blog.jetbrains.com/phpstorm/2014/11/database-language-injection-configuration/

You need to add \%\w+. in your Tools > Database section.