Function get_join_nested_sql_prompt

prompt/get_prompt.py:203–218

()

def get_join_nested_sql_prompt():
    sql_prompt = """{few_shots}### Database scheme: 
{table_info}

### Please think carefully about the related fields or calculation methods of '{main_metric}', then write valid SQLite to solve the following questions based on the above table information, and do not select extra columns that are not explicitly requested in the query.

### Query: {query}
### HINT: The question may needs nested queries like INTERSECT, UNION, EXCEPT, NOT IN.

### specification
1."LIMIT" just is used when explicitly requesting how much to retrieve in the query.
2.Don't use "IN", "OR", "LEFT JOIN" in sql because they aren't supported in execution engine, you can use "INTERSECT" or "EXCEPT" instead.
3.In sql, just select columns that are explicitly requested in the query.
4.The output format must strictly meet the given json specification: {{"the most related fields or calculation methods of '{main_metric}'": "zzz", "sql": "ccc"}}
"""
    return sql_prompt


def get_nested_sql_prompt():