Bulk insert SQL mode. Is it possible?

Bit of an old thread, but you can bulk insert with SQL mode queries in order to return the created IDs back to the app if the resource doesn't have the prepared statement setting enabled.

You essentially need to craft the values part of the SQL query with JS (specifics will depend on your array and DB structure), and then reference that in your insert query set to return whatever created record data.

1 Like