可以使用"LIKE“和SqlAlchemy在JSONB列表中搜索值吗？

from sqlalchemy import func
from sqlalchemy.dialects.postgresql import JSONB

from sqlalchemy import create_engine, Column, Integer
from sqlalchemy.dialects.postgresql import JSONB
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

# 创建数据库连接
engine = create_engine('postgresql://username:password@localhost:5432/database')
Session = sessionmaker(bind=engine)
session = Session()

# 创建模型
Base = declarative_base()

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

# 查询包含特定值的记录
result = session.query(MyModel).filter(func.jsonb_path_match(MyModel.data, '$[*] ? (@ like_regex "value")')).all()

# 打印结果
for row in result:
    print(row.id, row.data)