Support for hsqldb 2.0 seems to be simple.
i've checked the ddl generated for h2 in demo-order.
The only difference for autincrement is to replace
"not null autoincrement" with "GENERATED BY DEFAULT AS IDENTITY not null".
The "not null" must be after the "GENERATED" part, but this is hard coded in ebean.