Ability to make the "..." pattern configurable?

[asser-dk]

I was wondering how you would feel about adding an option to configure the "..." pattern to our own liking?

This is mainly useful for users with IDE's that offer syntax highlighting and sql command executions directly from their IDE (like Rider). The "..." is seen as a syntax error. If we had the ability to change the pattern to maybe a comment (eg. /*...*/) we could still leverage these features :)

Edit: The "..." pattern also causes all my bulk insert statements to show up as errors in the Rider's error/problem list and it just adds a lot of clutter.

The benefits here are pretty much only Quality of Life improvements

[ejball]

A configurable pattern would be challenging, but I would not object to adding support for /*...*/.

[asser-dk]

Without having thoroughly read the code it seems like one would "just" have to change the pattern in this line:

DapperUtility/src/Faithlife.Utility.Dapper/BulkInsertUtility.cs

Lines 260 to 261 in 748f7c6

	static readonly Regex s_valuesClauseRegex = new Regex(
	@"\b[vV][aA][lL][uU][eE][sS]\s*(\(.*?\))\s*\.\.\.", RegexOptions.CultureInvariant | RegexOptions.Singleline | RegexOptions.RightToLeft);

So that the last part (\.\.\.) could optionally be a regex you supply yourself. But support for a /*...*/

I could try fiddling with it a bit and send a PR one of these days :)