Closed
Description
We should provide a pluggable mechanism to provide a default Dialect detection from a ConnectionFactory. Right now, we provide a static mapping in Database that matches against ConnectionFactoryMetadata.getName().
A pluggable mechanism should discover available dialects from the class path (via SpringFactoriesLoader), apply ordering to allow overrides and select a Dialect based on a ConnectionFactory`.
We also should provide a generic dialect that allows interaction on plain SQL level. Advanced features such as array support, pagination and type contributions for object mapping are not supported by the generic dialect.