title: Column Alias Too Long in sqlalchemy/Sybase ASE
body: <p>I have sqlalchemy ORM mappings over a Sybase database. Some of my table names are fairly long, and I am getting the following error:</p>
  
  <pre><code>DBAPIError: (Error) ('HY000', "[HY000] [DataDirect][ODBC Sybase Wire Protocol driver]
  [SQL Server]The column heading that starts with 'RISK_AGGREGATION_GROUP_id_risk_agg' is 
  too long. Maximum length is 30.
  </code></pre>
  
  <p>Is there any way I can either:</p>
  
  <p>a) 'alias' the table inside sqlalchemy so that it uses shorter column aliases</p>
  
  <p>b) increase the 30 character limit</p>
  
  <p>I realise I can create view inside the database but would rather not touch it.</p>
  
  <p>thanks</p>