This project will expand the query language of APIv4 to increase functionality. Implementing this will enhance the capabilities of APIv4-based Smart Groups; without this their utility will be limited to simple queries. This is also a prerequisite to the Search Builder UI project.

Tasks:

• Implement Having, Group By parameters.
• Enable use of SQL Functions like SUM().
• Implement explicit joins.
• Implement a way to add subquery expressions to an API call.