def generate_prompt_with_examples()

in skills/text_to_sql/evaluation/prompts.py [0:0]

• 5 lines of code
• 1 McCabe index (conditional complexity)

def generate_prompt_with_examples(context):
    user_query = context['vars']['user_query']
    examples = """
        Example 1:
        <query>List all employees in the HR department.</<query>
        <output>SELECT e.name FROM employees e JOIN departments d ON e.department_id = d.id WHERE d.name = 'HR';</output>

        Example 2:
        User: What is the average salary of employees in the Engineering department?
        SQL: SELECT AVG(e.salary) FROM employees e JOIN departments d ON e.department_id = d.id WHERE d.name = 'Engineering';

        Example 3:
        User: Who is the oldest employee?
        SQL: SELECT name, age FROM employees ORDER BY age DESC LIMIT 1;
    """

    schema = get_schema_info()

    return f"""