sqlalchemy Connecting Implicit Execution
Example
If you only want to execute a single statement, you can use the engine directly and it will open and close the connection for you:
result = engine.execute('SELECT price FROM products')
for row in result:
print('Price:', row['price'])
