How can I use multiple parameters using pandas pd.read_sql_query?
<p>I am trying to pass three variables in a sql query. These are region, feature, newUser. I am using SQL driver SQL Server Native Client 11.0. </p>

<p>Here is my code  that works.</p>

<pre><code>query = "SELECT LicenseNo FROM License_Mgmt_Reporting.dbo.MATLAB_NNU_OPTIONS  WHERE Region = ?"

data_df = pd.read_sql_query((query),engine,params={region})
</code></pre>

<p>output.</p>

<pre><code>     LicenseNo
 0           12
 1            5
</code></pre>

<p>Instead i want to pass in three variables and this code does not work.</p>

<pre><code>query = "SELECT LicenseNo FROM License_Mgmt_Reporting.dbo.MATLAB_NNU_OPTIONS WHERE Region = ? and FeatureName = ? and NewUser =?"

nnu_data_df = pd.read_sql_query((query),engine,params={region, feature, newUser})
</code></pre>

<p>Output returns an empty data frame.</p>

<pre><code>Empty DataFrame
Columns: [LicenseNo]
Index: []
</code></pre>