# Class: InsertQuerySelectValuesConverter

Defined in: packages/core/src/transformers/InsertQuerySelectValuesConverter.ts:13

Utility to convert INSERT ... VALUES statements into INSERT ... SELECT UNION ALL form and vice versa. Enables easier column-by-column comparison across multi-row inserts.

Constructors

Constructor

new InsertQuerySelectValuesConverter(): InsertQuerySelectValuesConverter

Returns

InsertQuerySelectValuesConverter

Methods

toSelectUnion()

static toSelectUnion(insertQuery): InsertQuery

Defined in: packages/core/src/transformers/InsertQuerySelectValuesConverter.ts:18

Converts an INSERT query that uses VALUES into an equivalent INSERT ... SELECT UNION ALL form. The original InsertQuery remains untouched; the returned InsertQuery references cloned structures.

Parameters

insertQuery

InsertQuery

Returns

InsertQuery

---

toValues()

static toValues(insertQuery): InsertQuery

Defined in: packages/core/src/transformers/InsertQuerySelectValuesConverter.ts:65

Converts an INSERT query that leverages SELECT statements (with optional UNION ALL) into an equivalent INSERT ... VALUES representation.

Parameters

insertQuery

InsertQuery

Returns

InsertQuery