mpurbo

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.criterion.CriteriaQuery;
import org.hibernate.criterion.Order;

public class PostgisDistanceOrder extends Order {

    private boolean ascending;
    private String propertyName;
    private double fromLatitude;

mpurbo

SELECT ...
FROM ...
WHERE ...
ORDER BY ST_Distance(...)

mpurbo

Criteria criteria = session.createCriteria(Programmer.class);
criteria.add(Restrictions.sqlRestriction(
    "EXISTS(" +
        "SELECT pp.programmer_id " +
        "FROM programmers_projects pp " +
        "WHERE " +
        "pp.programmer_id = {alias}.programmer_id AND "     +
        "pp.project_id IN (1, 2) )"
));

mpurbo

SELECT pg.*
FROM programmers pg
WHERE EXISTS(
    SELECT pp.programmer_id
    FROM programmers_projects pp
    WHERE
        pp.programmer_id = pg.programmer_id AND
        pp.project_id IN (1, 2) -- or whatever condition to filter the projects
)