merge
open fun merge(dest: Table, source: Table, transaction: Transaction, clauses: List<MergeStatement.Clause>, on: Op<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 another table.
Parameters
dest
The table that will be modified.
source
The table 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.