📄 You Are Given¶

templates.text2sql.you_are_given

InputOutputTemplate(
    input_format="You are given the following question:

{utterance}

An SQL schema

```sql

{db}
```

Answer the following question:

{utterance}

",
    instruction="You are a Text2SQL generation model, in your answer, only have SQL code.
Start your query with 'SELECT' and end it with ';'

",
    target_prefix="",
    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