SQLAlchemy bulk updates.

bulk_updates_sqlalchemy.py

""" Quick example showing how to do a bulk update into the database
    using SQLAlchemy, without interacting heavily with the ORM.
"""

from sqlalchemy.sql.expression import bindparam
stmt = addresses.update().\
    where(addresses.c.id == bindparam('_id')).\
    values({
        'user_id': bindparam('user_id'),
        'email_address': bindparam('email_address'),
    })

conn.execute(stmt, [
    {'user_id': 1, 'email_address' : '[email protected]', '_id':1},
    {'user_id': 1, 'email_address' : '[email protected]', '_id':2},
    {'user_id': 2, 'email_address' : '[email protected]', '_id':3},
    {'user_id': 2, 'email_address' : '[email protected]', '_id':4},
])

Hi @doobeh are you familiar with bulk_update_mapping.
WDYT compare to this https://docs.sqlalchemy.org/en/14/_modules/examples/performance/bulk_updates.html