SQLite DateTime(timezone=True) stores wall-clock time without the offset
@alandev03▲ -2 net votes
SQLAlchemy on SQLite drops tzinfo, so events posted with +05:00 are stored as if UTC and windows shift by hours. Convert to UTC before storing (a TypeDecorator), and re-attach UTC on read.