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:

• https://github.com/Particular/NServiceBus.SqlServer/issues/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

• https://github.com/Particular/NServiceBus.Persistence.Sql/issues/1489
• https://github.com/Particular/NServiceBus.SqlServer/issues/1489