ComparisonExpression.java

SELECT a FROM Author a WHERE a.firstName like ‘%and%’ and a.id >= 20 and size(author.books) >= 5

ConstructorProjection.java

SELECT new org.thoughts.on.java.model.AuthorValue(a.id, a.firstName, a.lastName) FROM Author a

Distinct.java

SELECT DISTINCT a.lastName FROM Author a

Downcasting.java

SELECT a, p FROM Author a JOIN treat (a.publications AS Book) p

EntityProjection.java

SELECT a FROM Author a

From.java

SELECT a FROM Author a

GroupBy.java

SELECT a.lastName, COUNT(a) FROM Author a GROUP BY a.lastName

Having.java

SELECT a.lastName, COUNT(a) AS cnt FROM Author a GROUP BY a.lastName HAVING a.lastName LIKE ‘B%’

InnerJoin.java

SELECT a, b FROM Author a JOIN a.books b

JoinCondition.java

SELECT a, p FROM Author a JOIN a.publications p ON p.publishingDate > ?1

LeftOuterJoins.java

SELECT a, b FROM Author a LEFT JOIN a.books b

OrderBy.java

SELECT a FROM Author a ORDER BY a.lastName ASC, a.firstName DESC

PathExpressions.java

SELECT b FROM Book b WHERE b.publisher.name LIKE ‘%es%

Polymorphism.java

SELECT p FROM Publication p

PolymorphismSubtype.java

SELECT b FROM BlogPost b

ScalarValueProjection.java

SELECT a.firstName, a.lastName FROM Author a

Subselect.java

SELECT a FROM Author a WHERE (SELECT count(b) FROM Book b WHERE a MEMBER OF b.authors ) > 1

ThetaJoin.java

SELECT b, p FROM Book b, Publisher p WHERE b.fk_publisher = p.id