title: How to access the results of queries?
body: <p>I am working on writing a simple test to validate that the number of distinct values in an "id" column matches the number of rows for each table. I am expecting to be able to access particular values of an object, but when I run code and try to print the value of my variable, I can see that my object is a sqlalchemy.engine.result.ResultProxy object at..., as opposed to being something human readable. I have been on the SQLAlchemy website for over an hour, and have googled several permutations of my question, but have not found what I am looking for.</p>
  
  <p>My code, with terminal output, is below:</p>
  
  <pre><code>from sqlalchemy import create_engine 
  engine = create_engine('postgresql://kyle.pekosh@localhost:5432/testload')
  connection = engine.connect()
  id_count = connection.execute('SELECT COUNT(DISTINCT(id)) FROM csv.agencies')
  id_count
  &lt;sqlalchemy.engine.result.ResultProxy object at 0x10357d290&gt;
  </code></pre>