The current HSQL syntax requires a LOCK statement to include several unnecessary keywords:
LOCK TABLE <my_table> READ
It would be nice to have TABLE as an optional keyword, and READ to be default mode. With this you could instead write:
The purpose of this is to increase compatibility with other SQL databases (like postgres).