title: Pass parameters to SQL CTEs using Python Pandas
body: <p><strong>I am using pandas.io.sql to execute a SQL script that contains CTE and would like to do something like this:</strong></p>
  
  <pre><code>import pandas.io.sql as psql
  param1 = 'park'
  param2 = 'zoo'
  
  sqlstr = ("""WITH CTE_A AS (    
                            SELECT * 
                            FROM A 
                            WHERE A.Location = param1),
                    CTE_B AS (
                              SELECT * 
                              FROM B 
                              WHERE B.Location = param2)
              SELECT A.*, B.*
              FROM C
              INNER JOIN A
              ON C.something = A.something
              INNER JOIN B
              ON C.something = B.something 
              WHERE C.combined = param1 || param2
              )
  </code></pre>
  
  <p><strong>I would like to do something like this</strong></p>
  
  <pre><code>    result = psql.frame_query(sqlstr, con = db, params = (param1,param2))
  </code></pre>
  
  <p><strong>Could anyone help me in passing the two parameters using Pandas?</strong></p>