title: SQLAlchemy: Suffix table name to output columns
body: <p>I have a query where I join multiple tables with similar column names. To disambiguate them, I want to suffix the table name to the column name like: <code>&lt;column_name&gt;_&lt;table_name&gt;</code>. There are hundreds of columns in each table, so I would like to do it programmatically.</p>
  
  <p>Is there a way to do something like?</p>
  
  <pre><code>sa.select([
      table1.c.suffix('_1'),
      table2.c.suffix('_2')]).
  select_from(table1.join(table2, table1.c.id == table2.c.id))
  </code></pre>