Yes, I know I asked this question before, and there were some answers
previously, one of them has led me to a solution I think works, haven't
quite got it functional yet, but it's close. I asked again because it's
been a while since the first time and I thought maybe someone else had an
easily
> It can theoretically support DISJOINT_BY_ID, but IIRC it does not.
Actually I was wrong about this one. DISJOINT_BY_ID works just fine with
SQLSelect, and will save you a lot of trouble mapping SQL:
List result = SQLSelect.query(Artist.class, "SELECT "
+ "#result('ARTIST_NAME'
Hi,
We may need to make it more obvious in the API, but SQLSelect only supports
JOINT prefetching [1]. It can't support disjoint, as Cayenne has no way of
building the right WHERE clause for prefetch queries. It can theoretically
support DISJOINT_BY_ID, but IIRC it does not.
So let's focus