如何使用带有sqlalchemy和postgres的嵌套jsonb进行筛选

from sqlalchemy import create_engine

# 创建数据库连接
engine = create_engine('postgresql://username:password@localhost:5432/database_name')

from sqlalchemy import Column, Integer, String, JSON
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class MyModel(Base):
    __tablename__ = 'my_table'
    
    id = Column(Integer, primary_key=True)
    data = Column(JSONB)

from sqlalchemy.orm import sessionmaker
from sqlalchemy import func

# 创建Session
Session = sessionmaker(bind=engine)
session = Session()

# 使用filter和jsonb函数进行筛选
result = session.query(MyModel).filter(MyModel.data['key'] == 'value').all()