While fixing HHH-12925, I realized we need to document:

• how the type auto-discovery works in regards to JPQL and native SQL queries,
• the JDBC type to Hibernate type contribution mechanism used to bypass the default Dialect mapping
• the native SQL explicit type binding mechanism via addScalar to fix the issue when multiple Types map the same JDBC Type.