APIv4 Query Improvements

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.

Related pull-requests:

#16947 - Support GROUP BY and aggregate functions (merged)
#17047 - Api4 Explorer: Support SQL functions and HAVING clause (merged)

Edited Apr 10, 2020 by totten

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information