Support more DocumentStores in Haystack 2.x

[julian-risch]

DocumentStores

### Tasks
- [ ] https://github.com/deepset-ai/haystack-core-integrations/issues/142
- [ ] https://github.com/deepset-ai/haystack-core-integrations/issues/143
- [ ] Weaviate
- [x] Qdrant
- [x] Pinecone
- [x] InMemory
- [x] Elasticsearch
- [x] Opensearch
- [x] Chroma

[varuna82]

Hi, any plan to support Azure AI Search.

[sjrl]

It seems that we can check off Weaviate @julian-risch?

Integration page here: https://github.com/deepset-ai/haystack-core-integrations/tree/main/integrations/weaviate