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)