如何在JPA中编写动态sql查询来查询jsonb列中的数据？

@Entity
@Table(name = "users")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(columnDefinition = "jsonb")
    private String data;

    // 省略其他属性和方法
}

public List<User> searchUsersByJsonb(String key, String value) {
    CriteriaBuilder cb = entityManager.getCriteriaBuilder();
    CriteriaQuery<User> query = cb.createQuery(User.class);
    Root<User> root = query.from(User.class);

    // 构建查询条件
    Expression<String> jsonbColumn = root.get("data");
    Predicate condition = cb.equal(cb.function("jsonb_extract_path_text", String.class, jsonbColumn, key), value);

    // 设置查询条件
    query.where(condition);

    // 执行查询
    TypedQuery<User> typedQuery = entityManager.createQuery(query);
    return typedQuery.getResultList();
}