sql-kit icon indicating copy to clipboard operation
sql-kit copied to clipboard

Add configuration option for dialects without multi row insert support

Open lovetodream opened this issue 3 years ago • 1 comments

This change adds a configuration parameter (SQLDialect.supportsMultiRowInsert) to support dialects that do not support multi row inserts (e.g. Oracle). This is true by default. If false, a warning will be logged once multiple rows are about to be inserted into the database within a single statement.

lovetodream avatar Dec 18 '22 10:12 lovetodream

It might be more appropriate to throw an error, because the statement will most likely fail anyways. I'd like to hear some opinions about this.

lovetodream avatar Dec 18 '22 17:12 lovetodream

Closing this out due to age and the existing difficulty of dealing with lack of support for various other features by specific databases.

gwynne avatar Sep 22 '24 18:09 gwynne