product_obj = products.all()[0]
db.session.expunge(product_obj)
make_transient(product_obj)
product_obj.product_uid = 'something'
db.session.add(product_obj)
How to clone a sqlalchemy db object with new primary key