SQLAlchemy Data Types

Learn what the data types of SQLAlchemy are and how a mapping of data types takes place from Python to SQLAlchemy to SQL.

Python types and their mapping

Each type defined in the example below corresponds to a common SQL data type, but the exact mapping may vary from database to database since they don’t all support the same types. Here are some of the more common types and how they map from Python types to SQLAlchemy types to SQL types.

Get hands-on with 1200+ tech skills courses.