title: SQLAlchemy: Operating on results
body: <p>I'm trying to do something relatively simple, spit out the column names and respective column values, and possibly filter out some columns so they aren't shown.</p>
  
  <p>This is what I attempted ( after the initial connection of course ):</p>
  
  <pre><code>metadata = MetaData(engine)
  
  users_table = Table('fusion_users', metadata, autoload=True)
  
  s = users_table.select(users_table.c.user_name == username)
  results = s.execute()
  
  if results.rowcount != 1:
      return 'Sorry, user not found.'
  else:
      for result in results:
      for x, y in result.items()
          print x, y
  </code></pre>
  
  <p>I looked at the API on SQLAlchemy ( v.5 ) but was rather confused. my 'result' in 'results' is a RowProxy, yet I don't think it's returning the right object for the .items() invocation. </p>
  
  <p>Let's say my table structure is so:</p>
  
  <pre><code>user_id    user_name    user_password    user_country
  0          john         a9fu93f39uf      usa
  </code></pre>
  
  <p>i want to filter and specify the column names to show ( i dont want to show the user_password obviously ) - how can I accomplish this?</p>