[Python] Pass comma delimited values as bind variable value to oracledb cursor

I have a query wherein it has in clause.

e.g.

select * from table where column1 in ('value1', 'value2', 'value3');


I want to execute this query with list of (value1, value2 and value3, valueN) could be provided as BIND variable to above query when it gets executed via Python OracleDB cusrsor.

e.g.

with odbc.connect(
user=user,
password=password,
dsn=dsn
) as connection, open(Path("./", "adhoc_sqls", "query.sql").resolve(), "r", encoding="utf-8") as sql_file:
cursor = connection.cursor()
sql_query = sql_file.read()
cursor.execute(sql_query, <LIST_OF_VALUE>)


where query.sql looks like as follows:

select * from table where column1 in VALUE);

Continue reading...