EJB specification and WebSphere query language comparison
WebSphere Application Server extends the Enterprise JavaBeans (EJB) query language with elements of its own.
WAS supports the following extensions to the EJB query language.
Item
Delimited identifiers
Dependent Value object attributes used in path expressions
EJB Inheritance
EXISTS predicate
Java methods: EJB bean methods or value object methods dynamic query only Multiple element select clauses dynamic query only SQL Date/time expressions
Subqueries, group by, and having clauses
Related:
EJB query language Use EJB query Use the dynamic query service