mytable = Table('mytable', metadata, autoload=True)
s = mytable.select()
s = s.where(mytable.c.field1 == 'abc')
result = session.execute(s)
out = result.fetchall()
print(out)
i = insert(mytable)
i = i.values({'field1': 'value1', 'field2': 'value2'})
session.execute(i)
u = update(mytable)
u = u.values({'field3': 'new_value'})
u = u.where(mytable.c.id == 33)
session.execute(u)
Вставка и обновление с помощью ядра SQLAlchemy