Can we have more complex example .
We have multiple tables and foreign key relations. Although I am giving only 2 table in schema prompt, sql generated has some other table name which I didnt give. Also need to know how we can give column alias for the model to understand example nat_id is "Nationality ID" and Nat_code is ISO Nationality code. also column person_id can be referred as Profile ID or Customer ID or Person number. I tried generating the training file output file manually as we will not be connecting to database using this model. How can we train based on that output.json
Can we have more complex example .
We have multiple tables and foreign key relations. Although I am giving only 2 table in schema prompt, sql generated has some other table name which I didnt give. Also need to know how we can give column alias for the model to understand example nat_id is "Nationality ID" and Nat_code is ISO Nationality code. also column person_id can be referred as Profile ID or Customer ID or Person number. I tried generating the training file output file manually as we will not be connecting to database using this model. How can we train based on that output.json