Can mock-alchemy or alchemy-mock be used to mock session.execute(selectObject).where(...).scalars.fetchAll?

[RobertHana]

https://stackoverflow.com/q/69546839/6429049?sem=2

Can mock-alchemy or alchemy-mock be used to mock the following:

def fetch() -> List[MyEntity]:
  selectObject = sqlalchemy.select(MyEntity)
  with sqlalchemy.orm.Session(engine) as session:
    results = session.execute(selectObject)
    instances = results.scalars().fetchall()
    return instances

[kentbull]

I have a similar question minus the scalars() part. The fetchall() call is recognized by the mock yet it doesn't return the data I specify when using a UnifiedAlchemyMagicMock