pai.create using sqldatabase should have configuration to specify database schema

[kambeena]

🚀 The feature

Hi,

I am trying to create a pandas-ai schema from the database table. The table is not accessible from public schema. In the following source definition, there should be a config element for specifying schema, which should prefix table name. I have tried to configure table name as inventory.orders but in the resulting sql has table name as "inventory.orders" and the table name in paratheses caused sql execution error. Either add functionality or suggest.

source:
type: postgres
connection:
host: postgres-host
port: 5432
database: postgres
user: postgres
password: ******
table: orders
view: false

Thanks
Regards
Kamlesh Sharma

Motivation, pitch

I am getting error when trying to create schema from sql database table of PostgreSQL which was not accessible in public schema.

Alternatives

No response

Additional context

No response