1. Trim in HSQL for an unusual scenario    stackoverflow.com

Consider the following table with three columns TABLE [ID Name(varchar(4)) DESCR] PrimaryKey [ID, NAME] now I have to write a hql that looks like below

String hql = "from Table as table where table.id ...

2. how to transfer sql to hsql !    forum.hibernate.org

3. How can I translate this SQL to HSQL ?    forum.hibernate.org