querystring = (
    'select order_number, creation_date from table_name where order_number in ({})'
    .format(','.join(['?'] * len(orders))))
Appending to a Pandas Dataframe From a pd.read_sql Output