📄 You Are Given With Sql Prefix¶

templates.text2sql.you_are_given_with_sql_prefix

type: InputOutputTemplate
input_format: "You are given the following question:\n\n{utterance}\n\nAn SQL schema\n\n```sql\n\n{db}\n```\n\nAnswer the following question:\n\n{utterance}\n\n"
instruction: "You are a Text2SQL generation model, in your answer, only have SQL code.\nStart your query with 'SELECT' and end it with ';'\n\n"
target_prefix: "```sql\nSELECT "
output_format: {query}
postprocessors: 
  - processors.text2sql.get_sql
[source]

Explanation about InputOutputTemplate¶

Generate field ‘source’ from fields designated as input, and fields ‘target’ and ‘references’ from fields designated as output, of the processed instance.

Args specify the formatting strings with which to glue together the input and reference fields of the processed instance into one string (‘source’ and ‘target’), and into a list of strings (‘references’).

References: processors.text2sql.get_sql