I'm trying to implement faster SQLalchemy query with limit and offset as proposed here: https://github.com/sqlalchemy/sqlalchemy/wiki/WindowFunctionsByDefault
to solve the problem described here: memory-efficient built-in SqlAlchemy iterator/generator?
Copied the code from: https://github.com/sqlalchemy/sqlalchemy/wiki/WindowFunctionsByDefault to local environment and try to change the query at the main to fit my situation
session.execute(select([TableObject.__table__])).fetchall() works for me.
When I try to add limit(integer).offset(integer) like
session.execute(select([TableObject.__table__]).limit(integer).offset(3)).fetchall()
I get the following error {AttributeError}can't set attribute
How can I get the results of Select object query with these attributes?