mergeFrom
Represents the SQL statement that inserts, updates, or deletes records in a target table based on a comparison with a source table.
Return
A MergeTableStatement that can be executed.
Parameters
An instance of the source table.
A lambda function with SqlExpressionBuilder as its receiver that should return an Op<Boolean>
condition. This condition is used to match records between the source and target tables.
A lambda where MergeTableStatement can be configured with specific actions to perform when records are matched or not matched.
Represents the SQL statement that inserts, updates, or deletes records in a target table based on a comparison with a select query source.
Return
A MergeSelectStatement which represents the MERGE operation with the configured actions.
Parameters
The aliased query for a complex subquery to be used as the source.
A lambda with a receiver of type SqlExpressionBuilder that returns an Op<Boolean>
condition. This condition is used to match records between the source query and the target table.
A lambda where MergeSelectStatement can be configured with specific actions to perform when records are matched or not matched.