I use the H2 database in PostgreSQL mode, in development.

# H2 PostgreSQL Mode: h2db database in local file.
jakarta.persistence.jdbc.driver=org.h2.Driver
jakarta.persistence.jdbc.user=tester
jakarta.persistence.jdbc.password=123456
jakarta.persistence.jdbc.url=jdbc:h2:file:./target/test-database/h2db;MODE=PostgreSQL

hibernate.dialect=org.hibernate.dialect.PostgreSQL10Dialect

I just updated my Hibernate dependencies to 6.x from 5.x. Specifically, to 6.2.7.Final.

When I use PostgreSQL10Dialect, I get this warning:

WARN deprecation - HHH90000026: PostgreSQL10Dialect has been deprecated; use org.hibernate.dialect.PostgreSQLDialect instead

But when I use PostgreSQLDialect, I get this warning:

WARN Dialect - HHH000511: The 2.2.0 version for [org.hibernate.dialect.PostgreSQLDialect] is no longer supported, hence certain features may not work properly. The minimum supported version is 10.0.0. Check the community dialects project for available legacy versions.

What is the plan, going forward, to select a Hibernate dialect for H2 in PostgreSQL mode?

I would like to use a proper dialect setting that does not produce a warning.

Note: H2 supports several SQL modes: IBM DB2, Apache Derby, HSQLDB, MS SQL Server, MySQL, Oracle, and PostgreSQL.

I am concerned that the deprecated PostgreSQL10Dialect will be removed before H2 SQL Modes is supported by Hibernate dialects.