Kasper Sørensen created METAMODEL-48:
----------------------------------------

             Summary: Subquery as operand for FilterItem
                 Key: METAMODEL-48
                 URL: https://issues.apache.org/jira/browse/METAMODEL-48
             Project: Metamodel
          Issue Type: Improvement
            Reporter: Kasper Sørensen


Currently FilterItem only supports 'hard' operand values such as Strings, 
integers, dates and lists+arrays of these.

But often it would be good to have support for dynamic subqueries as well. A 
few examples of usage would be:

For querying:
SELECT foo FROM bar WHERE id = (SELECT MAX(id) WHERE baz = 42)

For deletion:
DELETE FROM foo WHERE bar IN (SELECT baz FROM fourtytwo)



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to