We also use HSQL to unit test our Oracle code and can't write tests against a segment of our system because CONNECT BY PRIOR is not supported. I don't see a voting mechanism here, but we would very much +1 this work.