Currently ibis supports create_table for creating (or replacing) a table, and insert for inserting new data into a table. Another common operation is upsert, which is supported by some backends. This is like insert, but also supports updating existing rows.

• For the data analysis DB tasks that ibis is targeted at is there a use case for this operation?
• What backends support this operation?
• If we add support, what options should Backend.upsert support?