CODE EXAMPLE FOR SQL

sqlalchemy return id after insert

f = Foo(bar='x')
session.add(f)
session.flush()

print(f.id) # will return the obj id