The following code returns error:
pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '@P1'. (102) (SQLExecDirectW)")

Python code is:

c, conn = connection()
 query = "SELECT case_Case_Number \
     FROM tbl_case \
     ?"
 c.execute(query, (workflow_eval_statement, ))

The workflow_eval_statement is:

WHERE case_Case_Number = '23-00000500' and case_Case_Status = 'In Process'   and case_Case_Source = 'Portal'

When I use that WHERE statement via a query directly into SQL Server to returns that record correctly, without error.

If I modify the program to hard code the field names and pass the values it works:

query = "SELECT case_Case_Number \
    FROM tbl_case \
    WHERE case_Case_Number = ? and case_Case_Status = ? and case_Case_Source = ?"
c.execute(query, (parm_case_id, parm_status, parm_source))

Results in no error

I also tried passing the pre-built WHERE clause with double quotes (see below) and get the same error.

WHERE case_Case_Number = "23-00000500" and case_Case_Status = "In Process"   and case_Case_Source = "Portal"

Any guidance is appreciated.