can I use multistep query engine with sql engine?

Please stand by @prathamesh4585 as I search the knowledge base. I normally take about 20 seconds or so. :wave:

----------------------
Yes, you can use the Multi-Step Query Engine with the SQL Query Engine in LlamaIndex. The Multi-Step Query Engine is designed to decompose complex queries into sequential subquestions, which can be particularly useful when working with structured data like SQL databases.

In the context of SQL, this could involve breaking down a complex query into simpler SQL queries, executing them sequentially, and using the results of one query to inform the next.

Here are the relevant guides for each:

• Multi-Step Query Engine Guide ()
• SQL Query Engine Guide ()

Please note that while these guides provide separate examples of using the Multi-Step Query Engine and the SQL Query Engine, they don't provide a specific example of using them together. You would need to integrate them according to your specific use case.
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------

@kapa.ai can I have control over the sub-questions Multi-Step Query Engine generates? with each sub-questions if I want to give some additional context to sql engine how can I do that?

Let me check the knowledge base for you. One moment! :books:

----------------------
The Multi-Step Query Engine in LlamaIndex is designed to automatically decompose complex queries into simpler sub-questions. However, the specific details of how you can control the generation of these sub-questions or provide additional context to each sub-question are not provided in the extracted information.

In general, the generation of sub-questions is likely determined by the underlying logic of the Multi-Step Query Engine, which is designed to break down complex queries into simpler ones that can be sequentially answered. Providing additional context to each sub-question would likely involve modifying this underlying logic.

For more detailed information on how to customize the behavior of the Multi-Step Query Engine, you may want to refer to the LlamaIndex documentation () or the source code () on GitHub.
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------

@kapa.ai if user asks questions like hi, hello, which do not require sql engine to query the database, will it be able to give general response? or do i have to handle it differently?

Let me check the knowledge base for you. One moment! :books:

----------------------
The Multi-Step Query Engine in LlamaIndex is designed to handle complex queries that require decomposition into simpler sub-questions. It's not explicitly designed to handle general conversational inputs like "hi" or "hello".

If you want your application to respond to such inputs, you might need to implement a separate logic to handle these general conversational inputs before passing more complex queries to the Multi-Step Query Engine. This could be done by checking if the user's input matches a list of predefined general inputs (like "hi", "hello", etc.) and responding accordingly.

However, the specific details of how to implement this are not provided in the extracted information. For more detailed guidance, you may want to refer to the LlamaIndex documentation () or the source code () on GitHub.
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------