Use List In Bind Parameters - SQLAlchemy

bindparameters.py

my_list = ['peach', 'grape', 'apple']
query_parameters = {}
counter = 1
for list_item in my_list:
  query_parameters["list_item" + str(counter)] = list_item
  counter += 1
  
where_clause = 'fruits IN(:' + ",:".join(query_parameters.keys()) + ')' # create clause to be inserted into query
query_text = db.text("""
 SELECT 
  fruits
 FROM table
 WHERE """ + where_clause + """
""")

result = db.engine.execute(query_text, **query_parameters)