In many places in my code I do something like table.to_pandas().to_records(). It could be nice to have a method that goes straight there. IDK, not a huge deal, the existing solution is really not that bad. But just wanted to get an issue up for discussion.

Based on @mw3i in #5391 (comment)_:

Sorry for the late reply. Since ibis doesn't have upsert, our team uses the dataset library for inserts/updates/upserts. We do all our normal code in ibis, and then updates/upserts are done with:

import dataset

params = f"{dialect}://{user}:{password}@{url}:{port}/{database}" # <-- sqlalchemy database uri string
with dataset.connect(params) as dbx:
    dbx[tablename].upsert_many(
        list_of_dictionaries, # <-- each dict is a db entry
        column_to_use_as_identifier,
    )