Shows a bulk update using SQLAlchemy ORM.

sqla_bulk_update.py

from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Boolean, String
from sqlalchemy.orm import sessionmaker

engine = create_engine('sqlite:///:memory:', echo=True)
session = sessionmaker(bind=engine)()
Base = declarative_base()

class User(Base):
  __tablename__ = 'users'
  name    = Column(String, primary_key=True)
  enabled = Column(Boolean)

  def __repr__(self):
    return f'User({self.name}, enabled={self.enabled})'

Base.metadata.create_all(engine)

session.add(User(name='a', enabled=True))
session.add(User(name='b', enabled=False))
session.add(User(name='c', enabled=True))
session.commit()

enabled = ['a', 'b']

session.query(User).update({User.enabled:User.name.in_(enabled)}, synchronize_session=False)

for user in session.query(User):
  print(f'{user}')