def validate_sql_query()

in tools/database/querying.py [0:0]

• 9 lines of code
• 4 McCabe index (conditional complexity)

def validate_sql_query(query: Annotated[str, "SQL Query"]) -> ValidateSQLQueryResult:
    """
    Validate the syntax of an SQL query.
    Returns a ValidateSQLQueryResult indicating validity.
    """
    try:
        parsed = sqlparse.parse(query)
        if parsed and len(parsed) > 0:
            return ValidateSQLQueryResult(is_valid=True)
        else:
            return ValidateSQLQueryResult(is_valid=False, error="Query could not be parsed.")
    except Exception as e:
        return ValidateSQLQueryResult(is_valid=False, error=str(e))