Pinecone provider support for `pinecone-client`>=3

[rawwar]

trafficstars

closes: #37158

Adds support for pinecone-client >= 3.x

Migration checks

• [x] Index creation
• [x] handle updated(breaking change) response from list_indexes and list_collections
• [x] handle describe_index response change
• [x] handle changes to positional arguments in query method.
• [x] handle removal of multiple queries support using queries keyword in query method
• [x] handle removal of scale_index
• [x] PINECONE_DEBUG_CURL support for debug logs

Additional tasks:

• [x] Documentation update
• [x] changelog
• [x] add/update tests
• [x] add example dag's for new operators

[Taragolis]

Does it backward compatible? Does it break during upgrade?

Difficult to say right now, in general bump dependency version is not a breaking changes, if all other components remain unchanged or compatible.

[github-actions[bot]]

This pull request has been automatically marked as stale because it has not had recent activity. It will be closed in 5 days if no further activity occurs. Thank you for your contributions.

[rawwar]

I am not sure why a few tests are failing. But, I'm looking into it.

[rawwar]

@sunank200 , @Lee-W, Do you have any more feedback for the PR?