public static Criterion sqlRestriction(String sql,
Object value,
Type type)
Apply a constraint expressed in SQL, with the given JDBC parameter. Any occurrences of {alias} will be replaced by the table alias.

DetachedCriteria dc = collectDao.createDetachedCriteria();
dc.createAlias("requestUser", "user");
dc.createAlias("user.company", "cp");
dc.add(Restrictions.like("cp.name", "%" + cpName + "%"));    

dc.add(Restrictions.sqlRestriction("{alias}.title like ? escape'/'", StringUtil.escapeSQLLike(title), StringType.INSTANCE));