To connect to multiple tables in a database

[sunyan-SG]

I checked the PandasAI documentation, it seems that it doesn't support on accessing multiple tables when connecting to a database.
Is my understanding correct? if Yes, can pls add this new feature into PandasAI. If not, can pls show me how to specify multiple tables in database connector? thank you.

[phoenixor]

Have you solved this problem? I also need to connect multiple MySQL data tables for joint operation, but the connector of the official example needs to be passed into the table, as if a table needs a connector.

[naredlarohithreddy]

@phoenixor @sunyan-SG guys , are you able to solve the problem, if not how did you proceed ? any alternatives

[gdcsinaptik]

@sunyan-SG, @phoenixor, and @naredlarohithreddy in the 3.0 there will be more flexibility on data operations via a semantic data layer. The feature you are suggesting here is about having a dataframe getting data from multiple sqp tables?

[naredlarohithreddy]

yeah, need to have multiple tables in sql database , so that based on the input, the llm must be able to perform joins on the tables and give the results.