Yes, the main (only?) place I've used it myself is for COUNT, SUM type features. But I'm interested in what is needed for ObjectSelect to catch up to the common use cases. And also where people see the line between SQLTemplate and EJBQL.
Ari On 15/08/2016 5:04pm, Andrus Adamchik wrote: > EJBQL is more feature rich - aggregation, arithmetic operations, subqueries, > functions. So while I rarely use it myself, I can easily see use cases. > > Andrus > > >> On Aug 15, 2016, at 9:43 AM, Aristedes Maniatis <[email protected]> wrote: >> >> On 15/08/2016 4:38pm, Andrus Adamchik wrote: >>> >>>> On Aug 14, 2016, at 4:39 PM, Hugi Thordarson <[email protected]> wrote: >>>> >>>> Hi all! >>>> Does Cayenne’s EJBQL support LIMIT expressions? I see I can set a fetch >>>> limit on an EJBQLQuery, but it seems that this will just limit the size of >>>> the resultset generated by the query, not the SQL generation (resulting in >>>> huge execution times for large queries). >>>> >>>> Cheers, >>>> - hugi >>> >>> Yeah, the way it is implemented is not particularly efficient. The limit >>> functionality is external to the syntax, and hence doesn't make it to the >>> generated SQL. We can either patch EJBQL, or wait for the bright future >>> when EJBQL and ObjectSelect and made one :) >>> >>> Andrus >> >> >> Out of interest Hugi, why are you using EJBQL? Is this legacy code moved to >> Cayenne and this was the easiest way forward? Or are there features of >> Cayenne's incomplete EJBQL implementation you like better than the other SQL >> Template or ObjectSelect api? >> >> >> Ari >> >> >> >> >> >> -- >> --------------------------> >> Aristedes Maniatis >> GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A > -- --------------------------> Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
