SQLite — SQLAlchemy 2.0.0b1 documentation
From Get docs
Sqlalchemy/docs/latest/dialects/sqlite
SQLite
SQLite Data Types
As with all SQLAlchemy dialects, all UPPERCASE types that are known to be valid with SQLite are importable from the top level dialect, whether they originate from sqlalchemy.types or from the local dialect:
from sqlalchemy.dialects.sqlite import \
BLOB, BOOLEAN, CHAR, DATE, DATETIME, DECIMAL, FLOAT, \
INTEGER, NUMERIC, JSON, SMALLINT, TEXT, TIME, TIMESTAMP, \
VARCHAR
SQLite DML Constructs
Pysqlite
Aiosqlite
Pysqlcipher