是否可以使用Hibernate 5.3+ CriteriaBuilder添加嵌套的SELECT IN语句？

常规我想使用条件构建器创建以下SQL：

select * from ORDERS where sender='ABC' and receiver='DEF' and amount='500' and id IN (SELECT id FROM cc4.best_orders)

标准定义（cc4.best_orders是一个简单的sql视图）：

public class BestOrders implements Criterion {

private static final String SQL_CRITERIA =
            ".id IN (SELECT id FROM cc4.best_orders) ";

    @Override
    public TypedValue[] getTypedValues(Criteria criteria,CriteriaQuery criteriaQuery) {
        return new TypedValue[] {};
    }

    @Override
    public String toSqlString(Criteria criteria,CriteriaQuery criteriaQuery) {
        return criteriaQuery.getSQLAlias(criteria) + SQL_CRITERIA;
    }

}

客户电话：

//...Old deprecated working way

Criteria crit = getSession().createCriteria(Order.class);
crit.add(getRestriction("sender.id",sender));
crit.add(getRestriction("receiver.id",receiver));
crit.add(getRestriction("amount.id",dataType));
crit.add(new BestOrders());
crit.setReadOnly(true);
Order order = (Order) crit.uniqueResult();

//...New Hibernate 5.3+ way 

CriteriaBuilder cb = getSession().getcriteriaBuilder();
CriteriaQuery<Order> cr = cb.createQuery(Order.class);
Root<Order> root = cr.from(Order.class);
cr.select(root).where(
   cb.and(
         getEqualPredicate(root,cb,"sender.id",sender),getEqualPredicate(root,"receiver.id",receiver),"amount.id",dataType)

        //new BestOrders()   ----> how to add 'SELECT IN' here ?!

        )
   );
Query<Order> query = getSession().createQuery(cr);
Order order = query.uniqueResult();