How to write SQL clause were group of columns is in array of values

I want create a SQL query like this:
select * from table where (,table.state) in (values (80,'stateA'),(13,'stateB'))
But I don’t know how to group the columns to call the in_ method.

Thanks in advance.

Well Array is not standard SQL so python-sql does not implement them.

1 Like

Thank you very much for the answer Cedric, I solved it in the following way in case someone else needs it:

                (( & (table.state == 'stateA'))
                | (( & (table.state == 'stateB'))
                | (( & (table.state == 'stateC'))