I use SQLAlchemy and there are at least three entities: engine, session and connection, which have execute method, so if I e.g. want to select all records from table I can do this
engine.execute(select([table])).fetchall()
and this
connection.execute(select([table])).fetchall()
and even this
session.execute(select([table])).fetchall()
– the results will be the same.
As I understand it, if someone uses engine.execute it creates connection, opens session (Alchemy takes care of it for you) and executes the query. But is there a global difference between these three ways of performing such a
task?
