title: How do I make PyCharm recognize placeholders in SQL statements?
body: <p>I'm using PyCharm and I have an error on this SQL statement:</p>
  
  <pre><code>SELECT * FROM table WHERE id= %(id)s
  </code></pre>
  
  <p>The code syntax inspection says:</p>
  
  <pre><code>&lt;expression&gt; expected, got '%'
  </code></pre>
  
  <p>Is there a way to disable this error message? In other words, how do I make PyCharm recognize placeholders in SQL statements?</p>
  
  <p><strong>Edit</strong></p>
  
  <p>Here is my solution: </p>
  
  <p>For <code>%(id)s</code> and <code>%s</code> you have to had <code>%\((\w+)\)s</code> and <code>%s</code> in <code>Settings/Preferences | Tools | Database | User parameters</code> and select <code>All languages</code> not only SQL</p>