ESQL: Add abstract test cases for aggregation functions

[ivancea]

Scalar functions have the AbstractFunctionTestCase, which adds a ton of automatic testing to them. Aggregation functions currently have none. They just have some tests for the Aggregators themselves, but they aren't very "complete", and they don't cover the function as a whole (So an aggregator could not be being called at all).

We should have a similar test coverage for aggregators as we have for scalars.

• [x] Add base class for aggregation tests (https://github.com/elastic/elasticsearch/pull/110042)
• [x] Add tests for simple input+output
• [x] Add tests for intermediate states (https://github.com/elastic/elasticsearch/pull/110279)
• [x] Add test case generators for no rows (https://github.com/elastic/elasticsearch/pull/110279)
• [x] Add helpers to use intCases() (And similar) methods (https://github.com/elastic/elasticsearch/pull/110327)
• [x] Skip testcases with complex surrogates (E.g. mix of functions) (https://github.com/elastic/elasticsearch/pull/110579)
• [ ] Add tests for grouping aggregators

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)