SQLAlchemy types


  • Integer() - INT
  • String() - ASCII strings - VARCHAR
  • Unicode() - Unicode string - VARCHAR or NVARCHAR depending on database
  • Boolean() - BOOLEAN, INT, TINYINT depending on db support for boolean type
  • DateTime() - DATETIME or TIMESTAMP returns Python datetime() objects.
  • Float() - floating point values
  • Numeric() - precision numbers using Python Decimal()