Example Queries

// Java Persistence Query Language
?

// OOMEGA Query Language
Query(
   from(Person.CID),
   where(
      eq(
         nav( P(Person.P.children), P(Person.P.firstname) ),
         VSet("Christian", "Stefano")
      )
   )
);

// Java Persistence Query Language
SELECT p
FROM Person p
WHERE p.firstname = "Christian";

// OOMEGA Query Language
Query(
   from(Person.CID),
   where(
      eq( P(Person.P.firstname), V("Christian") )
   )
);

// Java Persistence Query Language
SELECT COUNT(p)
FROM Person p;

// OOMEGA Query Language
Query(
   select( countAgg() ),
   from(Person.CID)
);

// Java Persistence Query Language
SELECT AVG(p.yearOfBirth)
FROM Person p;

// OOMEGA Query Language
Query(
   select( avgAgg(P(Person.P.yearOfBirth)) ),
   from(Person.CID)
);

// Java Persistence Query Language
SELECT p
FROM Person p, IN(p.children) c
WHERE c.firstname = "Christian";

// OOMEGA Query Language
Query(
   from(Person.CID),
   where(
      subsetEq(
         VSet("Christian"),
         nav( P(Person.P.children), P(Person.P.firstname) )
      )
   )
);

// Java Persistence Query Language
SELECT DISTINCT p.lastname
FROM Person p;

// OOMEGA Query Language
Query(
   select( P(Person.P.lastname) ),
   distinct(true),
   from(Person.CID)
);

// Java Persistence Query Language
SELECT p.yearOfBirth, COUNT(p)
FROM Person p
GROUP BY p.yearOfBirth;

// OOMEGA Query Language
Query(
   select( P(Person.P.yearOfBirth), countAgg() ),
   from(Person.CID)
);

// Java Persistence Query Language
SELECT p.yearOfBirth, COUNT(p)
FROM Person p
GROUP BY p.yearOfBirth
HAVING p.yearOfBirth IN (1978,1979,1980);

// OOMEGA Query Language
Query(
   select( P(Person.P.yearOfBirth), countAgg() ),
   from(Person.CID),
   where(
      subset(
         P(Person.P.yearOfBirth),
         VSet(1978,1979,1980)
      )
   )
);

// Java Persistence Query Language
SELECT p
FROM Person p
WHERE SIZE(p.children) > 2;

// OOMEGA Query Language
Query(
   from(Person.CID),
   where(
      gt(
         size( P(Person.P.children) ),
         V(2)
      )
   )
);

// Java Persistence Query Language
SELECT emp
FROM Employee emp
WHERE emp.salary > ALL (
   SELECT m.salary
   FROM Manager m
   WHERE m.department = emp.department
);

// OOMEGA Query Language
Query(
   from(Employee.CID),
   where(
      gt(
         castNumber(P(Employee.P.salary)),
         max(
            nav( P(Employee.P.department), P(Department.P.managers), P(Employee.P.salary) )
         )
      )
   )
);