python - How can I write an update query with IN clause with SQLAlchemy with same efficiency as of plain SQL

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65879915/how-can-i-write-an-update-query-with-in-clause-with-sqlalchemy-with-same-efficie

Answer 1

you can do

"UPDATE item_recs SET deleted_at = :deleted_at 
WHERE project_id = :project_id
AND item_id IN :item_ids"

and then use a tuple as the value for item_ids

params = {"item_ids": (1602,1603,1604)}

of course, you'll use the params as the argument in the session.execute(sql, params) along with the values for project_id and deleted_at in it as well