Pyton pyodbc select where clause

Hello I am looking for a “bulk” select by pyodbc
Select col1, col2 from table 1 where col1=df[col] and col2=df[col2]
“select col1, col2 from table1 where col1, col2=” df_tupes
df_tupes would be [(col1val1, col2val1), (col1val2, col2val2)]

Not necessarily for two columns but multiple columns

You’re looking for the “in” keyword. E.g.

select col1, col2 from table1 where col1 in (value,value) and col2 in (value, value)

And here is a link to passing values by tuple.