Batching queries in to one transaction

What do the individual queries look like here? You can do bulk queries of almost any type possible in the RAW SQL mode of the mysql query editor, or you can use the structured bulk insert, bulk update, or bulk upsert options inside of GUI mode:

For bulk upserts or updates, the input is expecting an array of objects like this:
[ { "id": 1, "name": "my new name"}, { "id": 2, "name": "your new name"} ]

For an insert, it shouldn't need the primary key of the table since that is typically generated when a new record is created