There is via EJBQLQuery: http://cayenne.apache.org/doc30/ejbqlquery.html
The only limitation is that EJBQL query assembly is currently String- based.
Andrus On Apr 28, 2010, at 7:20 AM, Marek Šabo wrote:
Hi is there support for these sql commands directly in API (like orderings) or do they need to be hardcoded as SQL statements? Regards, M. Šabo