Align Cosmos query pipeline code with latest relational code

[ajcvickers]

[roji]

After some examination, most of the Cosmos query pipeline is in relatively decent shape - aligned more or less to the relational query pipeline; I did NRT annotating (#33584) and some cleanup/styling (#33637), but beyond that I think we should be good to go.

The part that likely requires attention and a possible rewrite/alignment is the shaper generation; assigning to @ajcvickers and @maumar. Note that there will likely be some shaper work as well for new features, e.g. complex type mapping.