LEGACY mode should provide compatibility with incorrectly implemented H2SequenceSupport and H2IdentityColumnSupport in Hibernate ORM, with exception for H2IdentityColumnSupport.getIdentitySelectString(), but this method doesn't look like being really required. It also provides compatibility for various other features controlled by flags in Mode class for better compatibility with H2 1.*.