BJ Freeman wrote:
> there is a sql ability in the webtools
> so I am sure that can be implemented in code.
That is not the same thing. That does a *raw* query to jdbc.
What I am talking about, is having the delegator parse the sql string,
do all mappings(entityname -> table name, field name -> column name,
etc), and then do the query.
This would even work for views. For example:
SELECT * FROM PartyContactWithPurpose;
That would be auto-converted to the appropriate real sql code on the
back end. You could also write sql code that does a join inline:
SELECT
a.partyId, a.partyTypeId,
b.firstName, b.lastName,
c.groupName
FROM
Party a LEFT JOIN Person b USING (partyId)
LEFT JOIN PartyGroup c USING (partyId)
;
