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.

[zev-yang]

May i know if it support the tables connection? i tried it in the platform and gave clear instruction, like "connect dataset 'testing' and dataset 'testing2' with the key 'area', and sum the sales for 'person Zhang1"... but it doesn't work.

thanks.