Which dialect do you use?

Because AFAICS, from SQLServer2005Dialect and superior, we use the with syntax: https://github.com/hibernate/hibernate-orm/blob/master/hibernate-core/src/main/java/org/hibernate/dialect/SQLServer2005Dialect.java#L66 .