For the record, I just opened a pull-request about that for HSQLDB. At least it should trigger a review to notice potential caveats I could have missed.
See https://github.com/hibernate/hibernate-orm/pull/642
Cheers