Converge One Vector DBs for both Unstructured & Stuctured Data - Is it possible?

[mraguth]

We are currently using DuckDB as our vector database for all unstructured data and MongoDB for pandas dataframes or structured data. I am aware that DuckDB handles parquet data very well. My request is whether it would be possible to add similar functionality (converting the DataFrame to a JSON string representation) in DuckDB, allowing us to use DuckDB as a single vector database for both unstructured and structured data. Your advice on this matter would be appreciated.

If possible, can I get a sample code with query engine please?

Links for vector index that we are using are below:
https://docs.llamaindex.ai/en/stable/examples/vector_stores/DuckDBDemo/
https://docs.llamaindex.ai/en/stable/examples/vector_stores/MongoDBAtlasVectorSearchRAGOpenAI/