[FEATURE] P1 Nested Function Support

[forestmvey]

Is your feature request related to a problem?
The nested query is supported in the legacy engine and not the V2 engine. As Legacy engine is becoming deprecated we need to support this functionality in the V2 engine. Aggregation nested queries in the legacy engine are only supported with json format. This give a lower priority for adding support in the V2 engine for nested aggregation queries.

Example:

SELECT * FROM nested_objects WHERE nested(message, message.info = 'b');
SELECT sum(reverse_nested(comment.likes,'~comment')) FROM nested_objects GROUP BY nested(message.info);
SELECT count(*) FROM nested_objects HAVING nested(message.info)

What solution would you like?
Port over functionality for the nested query to the V2 engine with the same functionality as in Legacy.

Release-Schedule

• P[1] WHERE clause support Syntax: nested(path, expression)
• P[1] GROUP BY clause support
• P[1] reverse_nested support
• P[1] HAVING clause support

What alternatives have you considered?
N/A

Do you have any additional context?
N/A