title: Getting different query results in SQL workbench and SQL-alchemy for distinct
body: <p>I am working on SQL-alchemy for my application but when I use expression language to query results, I'm not able to get the same result as in SQL workbench</p>
  <p>SQL - workbench query</p>
  <pre><code>SELECT DISTINCT(rule_id) FROM resultsdb.new_results where execution_id='2020-08-24 12:52:49.262783' and data_id='1T2C6';
  </code></pre>
  <p>Output:</p>
  <pre><code>['R03', 'R04']
  </code></pre>
  <p>SQL - alchemy query</p>
  <pre><code>engine.execute('use resultsdb')
  conn = engine.connect()
  executive_id='2020-08-24 12:52:49.262783'
  data_id = '1T2C6'
  conn.execute(text(&quot;SELECT DISTINCT(rule_id) FROM new_results WHERE execution_id=:x AND data_id=:y;&quot;), x=executive_id, y=data_id).fetchall()[0]
  </code></pre>
  <p>Output:</p>
  <pre><code>('R03',)
  </code></pre>
  <p>I am not able to understand what is the issue.</p>