Accessing EvaDB tables using Postgres query engine

[pchunduri6]

Search before asking

• [X] I have searched the EvaDB issues and found no similar feature requests.

Description

Currently, it is not clear whether we can access EvaDB tables using a different query engine like Postgres. This will be useful when we want to leverage Postgres features like window functions and string_agg on the output of EvaDB tables. One concrete workflow that benefits from this is RAG-based question-answering:

1. Create vector index of a document in EvaDB.
2. Use similarity to retrieve top-5 similar chunks to the user question.
3. Concatenate all the retrieved chunks in Postgres using group by and string_agg.
4. Run an LLM function on the concatenated output.

If this is not possible, we would need to add support for STRING_AGG and GROUP BY 'chunks' natively in EvaDB.

Use case

No response

Are you willing to submit a PR?

• [ ] Yes I'd like to help by submitting a PR!

[ryanmle2001]

Claimed for EvaDB Project 2 @jarulraj