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