SQLAlchemy:在JSON字段中按日期时间过滤

from sqlalchemy import Column, Integer, String, DateTime
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.dialects.postgresql import JSONB

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)
    name = Column(String)
    data = Column(JSONB)
    created_at = Column(DateTime)

from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
from sqlalchemy.sql import func

engine = create_engine('your_database_url')
Session = sessionmaker(bind=engine)
session = Session()

date_filter = '2022-01-01'  # 这里设置特定日期

query = session.query(User).filter(func.date(User.data['created_at']).astext >= date_filter)
results = query.all()

for user in results:
    print(user.name, user.data)