title: HSQL unexpected token in statement
body: <p>I have created in LibreOffice Base a simple database with few tables.
  I want to run the following query:</p>
  
  <pre><code>SELECT SUM( "Total price" ) AS "Expenses" FROM "Expenses" WHERE "the Name of the Ware" IS 'food' AND "Date" BETWEEN {d '2019-08-06' } AND {d '2019-08-20' }
  </code></pre>
  
  <p>but I get an error:</p>
  
  <blockquote>
    <p>SQL state: 37000 Errorcode: -11</p>
    
    <p>Unexpected token in statement [SELECT SUM( "Total price" ) AS
    "Expenses" FROM "Expenses" WHERE "the Name of the Ware" IS 'food' AND
    "Date" BETWEEN    '2019-08-06'   AND    '2019-08-20'  ]</p>
  </blockquote>
  
  <p>As one can see I am trying to get SUM of "Total price" values from the Expenses table's records where "the Name of the Ware" is 'food' and the Date is between two given dates.</p>
  
  <p>How can I achieve my goal?</p>