title: How to REPLACE INTO using MERGE INTO for upsert in Delta Lake?
body: <p>The recommended way of doing an upsert in a delta table is the following.</p>
  <pre><code>MERGE INTO users
  USING updates
  ON users.userId = updates.userId
  WHEN MATCHED THEN
        UPDATE SET address = updates.addresses
  WHEN NOT MATCHED THEN
        INSERT (userId, address) VALUES (updates.userId, updates.address)
  </code></pre>
  <p>Here <code>updates</code> is a table. My question is how can we do an upsert directly, that is, without using a source table. I would like to give the values myself directly.</p>
  <p>In <em>SQLite</em>, we could simply do the following.</p>
  <pre><code>REPLACE INTO table(column_list)
  VALUES(value_list);
  </code></pre>
  <p>Is there a simple way to do that for Delta tables?</p>