Make dialects extendable / public and allow customizing queries

[ramonsmits]

Describe the feature.

At the moment the dialect types are public but cannot be customized by users because the methods are internal and prevents users from tweaking certain SQL operations.

Is your feature related to a problem? Please describe.

Queries cannot be customized at the moment. Allowing queries to be customized could allow data to be stored with a different schema or allow to setup different indexed at table creation.

Describe the requested feature

Ability to customize queries. Solutions suggestions are

1. Use stored procedures for each operation
2. Probe the file-system for a query template

Describe alternatives you've considered

There aren't alternatives except branching the repo and maintain an independant fork.

Related

• https://github.com/Particular/NServiceBus.SqlServer/issues/1483