Allow customizing SQL queries

[ramonsmits]

Describe the feature.

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.

For example, is this would be possible the following issue could have been resolved by a user:

• Ability to use a single table for all uniquely identified instances of an endpoint (via a discriminator) #1482

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.

Additional Context

No response

Related

• Make dialects extendable / public and allow customizing queries NServiceBus.Persistence.Sql#1489
• Filtering/partitioning/segment column to support (temporary) segmented processing #1489