[Feature] Add support for pinecone local

[johannesgiani]

Is this your first time submitting a feature request?

• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing functionality

Describe the feature

With the introduction of pinecone local it is desirable to configure the provider to point against a configurable host for testing and development.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response

[anawishnoff]

Thanks for filing @johannesgiani - this is definitely something we'll look into, and I'll circle back if we have any updates.