title: org.hsqldb.HsqlException: unexpected token: WITH
body: <p>Im getting this exception when trying to execute a SELECT... WITH (NOLOCK).</p>
  
  <p>Does anyone know how to handle/overcome this?</p>
  
  <p>props:</p>
  
  <pre><code>database.jdbc.datasource.class=org.hsqldb.jdbc.JDBCDataSource
  database.jdbc.url=jdbc:hsqldb:mem:database;sql.syntax_mss=true;sql.regular_names=false
  </code></pre>
  
  <p>stacktrace:</p>
  
  <pre><code>Caused by: org.hsqldb.HsqlException: unexpected token: WITH
  at org.hsqldb.error.Error.parseError(Unknown Source)
  at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)
  at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
  at org.hsqldb.Session.compileStatement(Unknown Source)
  at org.hsqldb.StatementManager.compile(Unknown Source)
  at org.hsqldb.Session.execute(Unknown Source)
  ... 52 more
  </code></pre>