Table and Column alias #20
Description
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