Use of IN statement in query

[maaike3515]

Hi all,

I hope someone can help me find an answer on this question. I'm using the IN statement in SQL quite a lot to select multiple specific values from a column for example. However, it looks like the IN statement is not supported in the Trino Python client.
An example of how I would like to use the IN statement (but this is giving an error):

query_str = """SELECT * FROM table WHERE col1 = ? AND col2 IN (?) LIMIT 100"""

result = trino_client.run_query(query=query_str, params=[1, (2, 3, 4)])

Does anyone know if there is another way to get the same result or how I can use the IN statement?