feat: add support for IN (array) condition with update() and delete()

feat: add support for IN (array) condition with update() and delete() #6525