Sorry, I wasn’t aware of HQL and HSQLDB being different things 
Thanks for the answer and for pointing out that using function would tie my code to a particular db, which is certainly not what I want.
Sorry, I wasn’t aware of HQL and HSQLDB being different things
Thanks for the answer and for pointing out that using function would tie my code to a particular db, which is certainly not what I want.