title: SQL: escaping with backslash
body: <p>I'm writing a lexer for SQL for syntax coloring and have the problem of parsing code like</p>
  <pre><code>SELECT * FROM table t WHERE t.name LIKE 'FOO\_%' ESCAPE '\';
  </code></pre>
  <p>Is my understanding correct, that <code>\</code> escapes some characters like underscore (<code>\_</code>), but not if it is followed by a single quote (<code>\'</code>)? Does the escaping depends on the SQL dialect or is the behavior the same for all (or a lot of) dialects?</p>
  <p>Is it correct, that <code>'\'</code> usually would mean an incomplete string literal, because the backslash escapes the single quote?</p>