title: Retrieve query results as dict in SQLAlchemy
body: <p>I am using flask SQLAlchemy and I have the following code to get users from database with raw SQL query from a MySQL database:</p>
  
  <pre class="lang-py prettyprint-override"><code>connection = engine.raw_connection()
  cursor = connection.cursor()
  cursor.execute("SELECT * from User where id=0")
  results = cursor.fetchall()
  </code></pre>
  
  <p><code>results</code> variable is a tuple and I want it to be of type dict(). Is there a way to achieve this?</p>
  
  <p>when I was using pymysql to build the db connection I was able to do </p>
  
  <pre class="lang-py prettyprint-override"><code>cursor = connection.cursor(pymysql.cursors.DictCursor)
  </code></pre>
  
  <p>Is there something similar in SQLAlchemy?</p>
  
  <p>Note: The reason I want to do this change is to get rid of using pymysql in my code, and only use SQLAlcehmy features, i.e. I do not want to have ´´´import pymysql´´´ in my code anywhere.</p>