Text-to-SQL with extremely complex schema

I am developing a text-to-sql project with llms and sql server. where user will ask question in natural language and llms will wrtie sql query, run it on my database and then give me result in natural language. The problem is schema of database is huge and tables names,column names are not self explanatory. Most of the times two tables need to joined on more than one column and in where condition I consistanly want to have some conditions and …

column database deeplearning language llms natural natural language project query question schema server sql sql query tables text text-to-sql will