sql_tmpl = "delete from Data where id_data in (SELECT UNNEST(:iddata))" params = { 'iddata':[1, 2, 3, 4], } self.session.execute(text(sql_tmpl), params)