How to bind a multidimensional array about node-mssql HOT 3 CLOSED

import sql from 'mssql';

const fixtures = [
  { id: 1, name: 'Children Bicycles' },
  { id: 2, name: 'Comfort Bicycles' },
  { id: 3, name: 'Cruisers Bicycles' },
  { id: 4, name: 'Cyclocross Bicycles' },
  { id: 5, name: 'Electric Bikes' },
  { id: 6, name: 'Mountain Bikes' },
  { id: 7, name: 'Road Bikes' },
];

const pool = await sql.connect({ /* options */})
const transaction = pool.transaction();

try {
  await transaction.begin();

  const request = transaction.request();

  await request.batch`SET IDENTITY_INSERT production.categories ON`;

-  await request.batch`MERGE INTO production.categories AS target
+  await request.batch(`MERGE INTO production.categories AS target
  USING (
-    VALUES ${fixtures.map((category) => [category.id, category.name])}
+    VALUES ${fixtures.map((category) => `(${category.id}, '${category.name}')`).join(',\n')}
  ) AS source (id, name)
  ON target.id = source.id
  WHEN MATCHED THEN
    UPDATE SET name = source.name
  WHEN NOT MATCHED THEN
-    INSERT (id, name) VALUES (source.id, source.name);`;
+    INSERT (id, name) VALUES (source.id, source.name);`);

  await request.batch`SET IDENTITY_INSERT production.categories OFF`;
} catch (error) {
  console.error(error);
  await transaction.rollback();
} finally {
  await pool.close();
}