Hi Team

At a glance

The post discusses the differences between SQLAutoVectorQueryEngine and SQLJoinQueryEngine. The community members note that SQLAutoVectorQueryEngine inherits from SQLJoinQueryEngine and is maintained for backward compatibility, but may be deprecated. The community members suggest that deprecated methods or classes should be marked more clearly to avoid confusion.

The post also explains that SQLAutoVectorQueryEngine was the original implementation, but the community members later decided that SQLJoinQueryEngine can be used to join SQL with any query engine, making SQLAutoVectorQueryEngine redundant.

RRendy Febry

Hi Team

What's the fundamental different between SQLAutoVectorQueryEngine and SQLJoinQueryEngine? their description quite vague and similar

"""SQL + Vector Index Auto Retriever Query Engine.

This query engine can query both a SQL database
as well as a vector database. It will first decide
whether it needs to query the SQL database or vector store.
If it decides to query the SQL database, it will also decide
whether to augment information with retrieved results from the vector store.
We use the VectorIndexAutoRetriever to retrieve results.

"""SQL Join Query Engine.

This query engine can "Join" a SQL database results
with another query engine.
It can decide it needs to query the SQL database or the other query engine.
If it decides to query the SQL database, it will first query the SQL database,
whether to augment information with retrieved results from the other query engine.

2 comments

RRendy Febry

Hmm looks like, SQLAutoVectorQueryEngine is just inherit the main SQLJoinQueryEngine, and it only maintained for backward compatibility (deprecated)

If true, maybe we need to mark deprecated method/class more clearly, to avoid confusion

Plain Text

# NOTE: maintain for backwards compatibility
class SQLAutoVectorQueryEngine(SQLJoinQueryEngine):

LLogan M

Yea, the SQLAutoVectorQueryEngine was originally implemented. Then we decided that wait, you can join SQL with any query engine -- so then the SQLJoinQueryEngine came about

Add a reply

Find answers from the community

Hi Team