SQL Datatype Objects

• The Type Hierarchy
  • The “CamelCase” datatypes
  • The “UPPERCASE” datatypes
  • Backend-specific “UPPERCASE” datatypes
  • Using “UPPERCASE” and Backend-specific types for multiple backends
  • Generic “CamelCase” Types
    • BigInteger
    • Boolean
    • Date
    • DateTime
    • Enum
    • Float
    • Integer
    • Interval
    • LargeBinary
    • MatchType
    • Numeric
    • PickleType
    • SchemaType
    • SmallInteger
    • String
    • Text
    • Time
    • Unicode
    • UnicodeText
  • SQL Standard and Multiple Vendor “UPPERCASE” Types
    • ARRAY
    • BIGINT
    • BINARY
    • BLOB
    • BOOLEAN
    • CHAR
    • CLOB
    • DATE
    • DATETIME
    • DECIMAL
    • FLOAT
    • INT
    • JSON
    • INTEGER
    • NCHAR
    • NVARCHAR
    • NUMERIC
    • REAL
    • SMALLINT
    • TEXT
    • TIME
    • TIMESTAMP
    • VARBINARY
    • VARCHAR
• Custom Types
  • Overriding Type Compilation
  • Augmenting Existing Types
    • TypeDecorator
  • TypeDecorator Recipes
    • Coercing Encoded Strings to Unicode
    • Rounding Numerics
    • Store Timezone Aware Timestamps as Timezone Naive UTC
    • Backend-agnostic GUID Type
    • Marshal JSON Strings
  • Applying SQL-level Bind/Result Processing
  • Redefining and Creating New Operators
  • Creating New Types
    • UserDefinedType
  • Working with Custom Types and Reflection
• Base Type API
  • TypeEngine
    • TypeEngine.Comparator
    • TypeEngine.adapt()
    • TypeEngine.as_generic()
    • TypeEngine.bind_expression()
    • TypeEngine.bind_processor()
    • TypeEngine.coerce_compared_value()
    • TypeEngine.column_expression()
    • TypeEngine.comparator_factory
    • TypeEngine.compare_against_backend()
    • TypeEngine.compare_values()
    • TypeEngine.compile()
    • TypeEngine.dialect_impl()
    • TypeEngine.evaluates_none()
    • TypeEngine.get_dbapi_type()
    • TypeEngine.hashable
    • TypeEngine.literal_processor()
    • TypeEngine.python_type
    • TypeEngine.result_processor()
    • TypeEngine.should_evaluate_none
    • TypeEngine.sort_key_function
    • TypeEngine.with_variant()
  • Concatenable
    • Concatenable.Comparator
    • Concatenable.comparator_factory
  • Indexable
    • Indexable.Comparator
    • Indexable.comparator_factory
  • NullType
  • ExternalType
    • ExternalType.cache_ok
  • Variant
    • Variant.__init__()
    • Variant.with_variant()