Add aggregate method to MongoDB

[melohagan]

Description

You can now use aggregations in the MongoDB connector.

There are two modes:

• JSON
• Pipeline

In the JSON mode, you simply provide an array of objects that represent each stage, as per the API docs: https://www.mongodb.com/docs/manual/aggregation/#aggregation-pipeline-example

In the Pipeline mode, you are presented with stages that can be added with the UI. This might be more suitable for "low-code users".

Currently the json and pipeline modes store data separately, but it could be changed to allow mapping between the two.

Addresses:

• Improve the MongoDB First Query Experience #5387

Screenshots

JSON mode

Dropdown stages with templates:

Swap stages

[codecov-commenter]

Codecov Report

Merging #8117 (f9ed72f) into develop (a487dfc) will not change coverage.
The diff coverage is n/a.

@@           Coverage Diff            @@
##           develop    #8117   +/-   ##
========================================
  Coverage    67.08%   67.08%           
========================================
  Files          122      122           
  Lines         4123     4123           
  Branches       658      658           
========================================
  Hits          2766     2766           
  Misses         950      950           
  Partials       407      407           

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[Rory-Powell]

Nice work mel, this is definitely a more low-code solution. I was wondering about the new Flow configuration type, where is that set on the new UI? I wasn't sure from the screenshots, is it the Action Type select?

I was thinking the term Flow might be a bit of an overloaded, and possibly something that might make more sense is to display Action Type as Query Type and use JSON or Form as the values

[melohagan]

Nice work mel, this is definitely a more low-code solution. I was wondering about the new Flow configuration type, where is that set on the new UI? I wasn't sure from the screenshots, is it the Action Type select?

I was thinking the term Flow might be a bit of an overloaded, and possibly something that might make more sense is to display Action Type as Query Type and use JSON or Form as the values

Changed 'flow' to 'pipeline' and renamed "Action Type" to "Query Type"

[shogunpurple]

LGTM! Great work Mel