Use List In Bind Parameters - SQLAlchemy01 Aug 2014 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)