📄 You Are Given With Hint With Sql Prefix¶

templates.text2sql.you_are_given_with_hint_with_sql_prefix

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

{utterance}

An SQL schema

```sql

{db}
```

And hint:

{hint}

Answer the following question:

{utterance}

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

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