Suggestion: Allow configuration to chat against multiple data frames

[iainwallacebms]

It would be very useful if the querychat was able to chat against multiple datasets (e.g. multiple excel files)

[cpsievert]

It is possible to chat with multiple datasets independently, but it might be worth thinking through a way to allow the LLM to JOIN multiple datasets

https://posit-dev.github.io/querychat/py/build.html#multiple-datasets

[jnhyeon]

Thank you for creating this wonderful package.

I'm performing analysis on multiple tables in a PostgreSQL database.
For example, I have a customer list, a product list, and a product description table.
I'd like to analyze the gender and product type of customers who purchased a specific product by querying these tables.

I'd appreciate it if you could create a feature in QueryChat that combines multiple tables into a single query and then analyzes them.

Thank you.

[shahronak47]

https://posit-dev.github.io/querychat/py/build.html#multiple-datasets looks interesting.

@cpsievert Do we have similar example for R?