title: How can I autogenerate ORM code for SQLAlchemy when consuming TSQL (mssql on SQL Server) from python?
body: <p>SQLAlchemy relies on me building ORM classes like this:</p>
  
  <pre><code>from sqlalchemy import Column, DateTime, String, Integer, ForeignKey, func
  from sqlalchemy.orm import relationship, backref
  from sqlalchemy.ext.declarative import declarative_base
  Base = declarative_base()
  class Department(Base):
      __tablename__ = 'department'
      id = Column(Integer, primary_key=True)
      name = Column(String)
  </code></pre>
  
  <p>Is there a tool/script/program than can do this for me? </p>
  
  <p>For instance, in C#  I can just drag and drop data items from the Database explorer into VisualStudio and have Entity Classes autogenerated for me (SQL to LINQ). I'm looking for something similar for python. I'm working in VisualStudio and/or Spyder.</p>