Dialect is "dialect" because hibernate is about translating Java objects into relational databases, while relational databases have some uniform standards, such as SQL-92, but virtually every database, such as Oracle, MySQL, MS SQL Server, etc. in order to improve performance or add functionality, some additional standards or syntax are provided, so hibernate specifies a dialect dialect for each database in order to better fit a variety of relational databases.
You can see in hibernate that the dialect is actually just a class that transforms different data types and SQL syntax into a uniform format that hibernate can understand. Note, however, that it is not possible to use this database for object-relational conversions if there is no corresponding dialect,hibernate.
The last time I used a H2 database and found a H2 dialect, I could use hibernate immediately.
Dialect explanation in Hibernate