idevai

@Formula("JSON_VALUE(JSON_COLUMN, '$.my.json.property')")
private String myProperty;

idevai

cb.equal(cb.function("JSON_VALUE", String.class,
                    new HibernateInlineExpression(cb, "JSON_COLUMN"),
                    new HibernateInlineExpression(cb, "'$.my.json.property'")),
         new LiteralExpression<>((CriteriaBuilderImpl) cb, String.class, "somevalue"));

idevai

public class HibernateInlineExpression extends LiteralExpression<String> {

    public HibernateInlineExpression(CriteriaBuilder criteriaBuilder, String literal) {
        super((CriteriaBuilderImpl) criteriaBuilder, literal);
    }

    @Override
    public String render(RenderingContext renderingContext) {
        return getLiteral();
    }

idevai

CriteriaBuilder cb = getCriteria();

cb.equal(cb.function("JSON_VALUE", String.class,
                    cb.literal("JSON_COLUMN"), cb.literal("$.my.json.property")),
         "value");

/*
 * Results in ORA-40454: path expression not a literal
 */

idevai

SELECT
  JSON_QUERY(JSON_COLUMN, '$.my.json.property' WITH WRAPPER) AS PROP,
  JSON_VALUE(JSON_COLUMN, '$.another.json.property') AS PROP2
FROM MY_TABLE