Use case text-to-sql database explorer

[mrm1001]

Goal

The goal is to refine this task into smaller sub-tasks which might include a review of existing approaches (with limitations), creating a proposal, implementing the solution.

User story

Users can create a pipeline or component that gets instantiated with a database schema and a way to connect and query the database. The pipeline can take a user query and translate it to SQL.

See "Agent-driven navigation of the database" in https://haystack.deepset.ai/blog/business-intelligence-sql-queries-llm