ObjectNotExecutableError when executing any SQL query using AsyncEngine
As the exception message suggests, the str ‘SELECT id, name FROM item LIMIT 50;’ is not an executable object. To make it executable, wrap it with sqlalchemy.text. from sqlalchemy import text async with self.async_engine.connect() as con: query = “SELECT id, name FROM item LIMIT 50;” result = await con.execute(text(query)) async.connection.execute requires that its statement argument … Read more