mergeSelect
open fun mergeSelect(dest: Table, source: QueryAlias, transaction: Transaction, clauses: List<MergeStatement.Clause>, on: Op<Boolean>, prepared: Boolean): String
Generates the SQL MERGE command which synchronizes two datasets by inserting new rows, or updating/deleting existing ones in the target table based on data from subquery.
Parameters
dest
The table that will be modified.
source
The query providing the data for modification.
transaction
The transaction in which the operation will be executed.
clauses
A list of MergeStatement.When
instances describing the when
clauses of the SQL command.
on
The condition that determines whether to apply insertions or updates/deletions.