Valid SQL

Objective Validates if the text is a valid SQL statement, ensuring executable and accurate queries.

Interpretation A higher score indicates the text is not valid SQL. A lower (or zero) score indicates the query is valid.

Code Execution

metrics = [
    {
        "name": "Valid SQL",
        "config": {
            "model": "gpt-4o-mini",
            "provider": "openai"
        },
        "column_name": "your-column-identifier",
        "schema_mapping": schema_mapping
    }
]

Example

  • Prompt: “Provide a valid SQL query to select all records from the ‘users’ table.”

  • Context: “Must be syntactically correct.”

  • Response: SELECT * FROM users

  • Metric Output: {"score": 1, "reason": "Invalid SQL (missing semicolon in strict syntax)."}

Last updated

Was this helpful?