title: Use alias for column name in SQLAlchemy
body: <p>Suppose if I have a SQLAlchemy table as follows -</p>
  
  <pre><code>class Employee(Base):
      id = Column(Integer, primary_key=True)
      employee_desgination = Column(String)
  </code></pre>
  
  <p>I remember going through the docs once and seeing some way of using aliases for long column names and use shorter ones instead. For example, in the above table instead of calling <code>Employee.employee_designation</code> I'd like to use <code>Employee.emp_d</code> or something similar. I wasn't able to find the example again :/ I think you declare an <code>alias()</code> in the table definition, but I am not sure of the syntax.</p>