Querying multiple tables

[chimeracle]

I'm trying to query two tables inside a single database using the example in the Reflex docs as a base(code directly below), but I get the error "Warning: Failed to compile initial state with computed vars, excluding them: 'function' object has no attribute 'options'".

self.locations = session.exec(
                Properties.select.options(
                    sqlalchemy.orm.selectinload(Properties.Name),
                    sqlalchemy.orm.selectinload(Properties.PropertyID).options(
                        sqlalchemy.orm.selectinload(PropertyManagement.Manager)))).all()

I've also tried the select_from method from the SQLAlchemy docs to join the tables(code below) and do get the joined results, but as a sqlalchemy result object that I'm unable to understand how to pass to the frontend.

stmt = select(Properties.Name, PropertyManagement.Manager).select_from(Properties).join(PropertyManagement, PropertyManagement.PropertyID == Properties.PropertyID)
            locations = session.execute(stmt)

Does anyone have any guidance on how to either solve the error regarding the options attribute or how to use a "<class 'sqlalchemy.engine.result.ChunkedIteratorResult'>" in a rx.foreach operation inside a table?