Multi-parameter batch upsert statement execution

A computer-implemented method associated with a cloud computing database infrastructure, comprising:

• identifying, by a computer processor of an UPSERT batch optimization engine, an UPSERT VALUES (?, ?, ?, …) WITH PRIMARY KEY case;
• receiving batch parameters for the UPSERT VALUES (?, ?, ?, …) WITH PRIMARY KEY case;
• creating a temporary table with the received batch parameters;
• executing a single left outer join with the temporary table and an UPSERT target table;
• fetching a result of the single left outer join;
• dispatching, by a Data Manipulation Language (“DML”) execution engine, a set of rows to be inserted and a set of rows to be updated;
• and
• executing a partition-wise insert and update run in accordance with the set of rows to be inserted and the set of rows to be updated.

One or more non-transitory computer-readable media storing computer-executable instructions that, when executed by a computing system, cause the computing system to perform operations comprising:

• identifying, by a computer processor of an UPSERT batch optimization engine, an UPSERT VALUES (?, ?, ?, …) WITH PRIMARY KEY case;
• receiving batch parameters for the UPSERT VALUES (?, ?, ?, …) WITH PRIMARY KEY case;
• creating a temporary table with the received batch parameters;
• executing a single left outer join with the temporary table and an UPSERT target table;
• fetching a result of the single left outer join;
• dispatching, by a Data Manipulation Language (“DML”) execution engine, a set of rows to be inserted and a set of rows to be updated;
• and
• executing a partition-wise insert and update run in accordance with the set of rows to be inserted and the set of rows to be updated.