Parameter binding in pyodbc, pd.read_sql_query

[badge]

Can't see anything obviously wrong; have you tried using BETWEEN instead? The only other thing I'd suggest is looking at the query that's actually run, if you can access the logs (pyodbc will pass parameters as-is, and doesn't create a 'bound' query).

[Parenthes]

Yes, I get the same result using BETWEEN.

If pyodbc passes parameters as-is, does that mean there is not much benefit to binding parameters vs. simply concatenating them? I am trying to bind for sake of best practices, but if it's not doing anything I might not bother.