remove the raw sql query used to get skill requests for non-superusers

[yesyash]

requirement

• remove the raw sql query in UserSkillRepository and use some feature from the ORM instead to query all skill requests created by non superusers

[iamitprakash]

@PersistenceContext
private EntityManager entityManager;

CriteriaBuilder cb= entityManager.getCriteriaBuilder();
CriteriaQuery query= cb.createQuery(UserSkills.class);

        Root<UserSkills> userSkills = query.from(UserSkills.class);
        Join<UserSkills, Endorsement> endorsement= UserSkills.join("endorsements", JoinType.INNER);
        query.select(userSkills).where(cb.equal(endorsement.get("endorserId"), endorserId));

        skillRequests = entityManager.createQuery(query).getResultList();