HSQLDB supports full ANSI syntax where the keywords and trim character are optional..

I said the submitted patch(which was for the old version 1.8) was not quite right.

If the SQL generated by Hibernate follows ANSI and the examples below are generated, it should work:

trim (' space ')
trim (FROM ' space ')
trim ('=' FROM '==space==')
trim (BOTH '=' FROM '==space==')
trim (LEADING '=' FROM '==space==')

The single-quoted strings are the parameters.