SERVER-139448Needs Scheduling

Investigate mongosql translated pipelines for possible rewrites

There's some pipeline shapes visible in [their tests|https://github.com/mongodb/mongosql/blob/main/mongosql/src/air/desugarer/testdata/desugar_all.yml], but I think we can also just run the compiler separately to investigate interesting SQL queries. We could focus on how JOINs and subqueries, and other common SQL queries are translated. Then we can determine if there are any pipeline shapes we need to support better with rewrites and analysis, for example to ensure JOO can apply, we can us

Affected Versions
Versions known to exhibit this issue

No affected versions recorded.

Fixed Versions
Versions that include the fix

No fix available yet.

Components
Server components related to this issue

No components specified.

Labels
Tags and classification

No labels assigned.