Dynamic insert multiple

[g105b]

It's slow to perform 20,000 insert queries, but fast to insert a query with 20,000 rows.

[g105b]

If a bind value is passed of type array, this needs to trigger the special binder to inject a repeating query section.

One way it could do this is by detecting the brackets of the values part of the query, then converting it. Like the following:

Source SQL:

insert into User ( `id`, `name`, `email` )
values (:id, :name, :email)

Converted SQL:

insert into User ( `id`, `name`, `email` )
values (:id_00001, :name_00001, :email_00001),
(:id_00002, :name_00002, :email_00002),
(:id_00003, :name_00003, :email_00003),
(:id_00004, :name_00004, :email_00004),
(:id_00005, :name_00005, :email_00005)

[g105b]

Solution:

insert into User (`id`, `name`, `email`)
values ( :__dynamicValueset )

Expands into the converted SQL perfectly.