querystring = (
    'select order_number, creation_date from table_name where order_number in ({})'
    .format(','.join(['?'] * len(orders))))
df = pd.read_sql(querystring, cnxn, params=orders)
Добавление к кадру данных Pandas из вывода pd.read_sql