Connection details are poorly documented #1010

What's Missing?

As of right now, it's not clear to me how to:

1. Create a Composition pipeline
2. Have attributes from the resources in the P&T functions create connection secrets
3. Connect multiple Compositions together using those secrets.

A simple multi-Composition (v2) example using P&Ts connected by a secret would be useful.

The only documentation I could find is:
https://docs.crossplane.io/latest/guides/function-patch-and-transform/#composite-resource-connection-details

Simply adding these fields to the P&T Function doesn't work.