title: SQLAlchemy and Ambiguous Column name
body: <p>Ive had a good search on google but I cant seem to find an answer to this error in my case.</p>
  
  <p>Im not making any joins, Im literally just trying to get all from this table.</p>
  
  <p>All of the other queries work fine, but this seems to be messing up with this error:</p>
  
  <pre><code>InvalidRequestError: Ambiguous column name 'INMPTL_WIW_BATAM_STG.pers_no' in result set! try 'use_labels' option on select statement.
  </code></pre>
  
  <p>Model:</p>
  
  <pre><code>    batamStg = sa.Table("INMPTL_WIW_BATAM_STG", meta.metadata, 
      sa.Column("PERS_NO", sa.types.String(),primary_key=True),
      sa.Column("FIRST_NAME", sa.types.String()),
      sa.Column("LAST_NAME", sa.types.String()),
      sa.Column("KNOWN_AS", sa.types.String()),
      sa.Column("JOB_TITLE", sa.types.String()),
      sa.Column("MANAGER_NAME", sa.types.String()),
      sa.Column("MANAGER_ID", sa.types.String()),
      sa.Column("MANAGER_COST", sa.types.String()),
      autoload=True,
      autoload_with=engine)
  </code></pre>
  
  <p>View:</p>
  
  <pre><code>btm = meta.Session.query(model.BatamStaging).all();
  </code></pre>
  
  <p>There is only one column called Pers_no here and all of the primary keys are unique.</p>
  
  <p>The same error also occurs if I try to set LAST_NAME as the primary key.</p>
  
  <p>Has anyone else had this issue?</p>