I want to create a model where i can pass DDL and It should generate data dictionary from a DDL
I dont have an answer to your question. That said, please provide more details on what the model input and outputs are for readers to better understand your problem.
What is a DDL?
You should consider some prerequisites for a good output. E.g., the DDL must contain descriptive comments for every table and field. Thus, if the real value of a data dictionary are the descriptions of every table and field, wouldn’t it be better to refine the DDL first with a good prompt, and then use another prompt to generate the data dictionary, which would contain almost the same value (table and field descriptions) but in another format? I don’t think you need to create a model for that. I believe a couple of good prompts and a good LLM selection would be sufficient.