HSQL has built-in GUI query tool called Database manager. In the directory of the database files run:
java -cp ../lib/hsqldb.jar org.hsqldb.util.DatabaseManager
and then setting the config to:
jdbc:hsqldb:file:databaseName
Allowed me to edit what I needed in a really convenient way.