[BUG]: Bulk insert multiple entities without need to use spread operator

[krzkaczor]

What version of drizzle-orm are you using?

0.21.1

Describe the Bug

As far as I can tell, the only way to insert multiple entities in a single query with insert is to use values with multiple arguments (use spread operator) ie:

await db.insert(users).values(...newUsers)

This can easily lead to RangeError: Maximum call stack size exceeded if there are thousands (~20k and more) of entities being sent.

Passing entities as an array should mitigate this problem.

[dankochetov]

Interesting! We weren't aware of that. Will work on implementing passing an array directly. Thanks!

[dankochetov]

Fixed in 0.23.0

[krzkaczor]

I think this is a commit that suppose to fix this (sidenote: maybe linking issues in PRs would help tracking it...).

This PR, unfortunately doesn't contain any tests and doesn't actually fix the problem. insert still blows up with Maximum call stack size exceeded when a lot of items are passed at once.

[dankochetov]

@krzkaczor are you passing the items as a regular array?

[krzkaczor]

yes

[jakeleventhal]

#797 (comment) Still an issue here