upsertMany should split to batch

[wenerme]

Describe the bug

Stack trace

To Reproduce

upsertMany with a lot rows.

Expected behavior

Additional context

Versions

Dependency	Version
node	?
typescript	?
mikro-orm	?
your-driver	better-sqlite

[B4nan]

What does "a lot" mean, how complex your entity is? Note that I can see from your screenshot that you don't await the upsert call.

[rubiin]

Describe the bug

**Stack trace**

To Reproduce

upsertMany with a lot rows.

Expected behavior

Additional context

Versions

Dependency Version
node ?
typescript ?
mikro-orm ?
your-driver better-sqlite

https://antfu.me/posts/why-reproductions-are-required

[wenerme]

for SQLIite SQLITE_MAX_COMPOUND_SELECT=500 (https://www.sqlite.org/limits.html), it's easy to rich the limit when using batch, maybe related to how sqlite is generated, I think mikro orm should support the automatic batch split or allowed pass a batch size options.

I think this error is common enough, it's easy to get the point.