config/prompts.yaml

# Prompt Templates Configuration
prompts:
  # Template file paths
  files:
    presto: "prompts/template_presto.txt"
    bigquery: "prompts/template_bigquery.txt"
    snowflake: "prompts/template_snowflake.txt"
  
  # Fallback template for missing files
  fallback: |
    You are an expert SQL developer specializing in {dialect} SQL dialect.

    Given the following database schema and a natural language question, generate a correct SQL query in {dialect} syntax.

    Database Schema:
    {{schema}}

    Question: {{question}}

    Requirements:
    - Use proper {dialect} SQL syntax
    - Ensure the query is syntactically correct
    - Return only the SQL query, no explanations

    SQL Query:
  
  # Template placeholders
  placeholders:
    schema: "{{schema}}"
    question: "{{question}}"
    dialect: "{dialect}"
  
  # Template sections
  sections:
    system: "You are an expert SQL developer specializing in {dialect} SQL dialect."
    context: "Given the following database schema and a natural language question, generate a correct SQL query in {dialect} syntax."
    schema: "Database Schema:\n{{schema}}"
    question: "Question: {{question}}"
    requirements: |
      Requirements:
      - Use proper {dialect} SQL syntax
      - Ensure the query is syntactically correct
      - Return only the SQL query, no explanations
    output: "SQL Query:"

# Error Messages
errors:
  template_not_found: "Template file not found: {path}"
  invalid_template: "Invalid template format"
  missing_placeholder: "Missing required placeholder: {placeholder}"

# Template Validation
validation:
  required_placeholders:
    - "schema"
    - "question"
  optional_placeholders:
    - "dialect"
  max_length: 10000
  min_length: 100