Training Text-To-SQL models

Does anyone have any suggestions on how to train a model for text-to-SQL tasks? I also want my model to work with a specific schema only. How can I achieve that?

The idea is to train a model with a specific dataset that represents a variety of queries based on my database schema. After the training, I want my model to return only answers related to my schema.