UPSERT INTO table [[AS] alias] (column,...) VALUES (value,...)
UPSERT (MERGE) command
MERGE) command is used to add or update records.
The non-ANSI version of
UPSERT that is implemented in Teiid is a modified INSERT statement
that requires that the target table has a primary key, and that the target columns cover the primary key.
Before it performs an
UPSERT operation checks whether a row exists,
and if it does,
UPSERT updates the current row rather than inserting a new one.
UPSERT INTO table (column,...) query
UPSERT pushdownIf an