Function AnalyzeTokenError

pkg/errors/suggestions.go:264–295

AnalyzeTokenError produces a context-aware suggestion string for token-level parse errors. It inspects the actual and expected token types to provide specific guidance - for example, detecting when a quoted string is used where a number is expected, or when an unknown identifier looks like a misspel

(tokenType, tokenValue, expectedType string)

//
// Returns a human-readable suggestion string; never returns empty string.
func AnalyzeTokenError(tokenType, tokenValue, expectedType string) string {
	// String literal where number expected
	if tokenType == "STRING" && (expectedType == "NUMBER" || expectedType == "INTEGER") {
		return fmt.Sprintf("Expected a number but found a string literal '%s'. Remove the quotes if this should be numeric.", tokenValue)
	}

	// Number where string expected
	if tokenType == "NUMBER" && expectedType == "STRING" {
		return fmt.Sprintf("Expected a string but found a number %s. Add quotes if this should be a string literal.", tokenValue)
	}

	// Identifier issues
	if tokenType == "IDENT" {
		suggestion := SuggestKeyword(tokenValue)
		if suggestion != "" && suggestion != strings.ToUpper(tokenValue) {
			return fmt.Sprintf("Unknown identifier '%s'. Did you mean the keyword '%s'?", tokenValue, suggestion)
		}
	}

	// Missing operator between tokens
	if tokenType == "IDENT" && expectedType == "OPERATOR" {
		return "Expected an operator (=, <, >, AND, OR, etc.) between expressions."
	}

	// Unclosed parenthesis
	if tokenType == "EOF" && expectedType == "RPAREN" {
		return "Unclosed parenthesis detected. Check that all opening parentheses have matching closing parentheses."
	}

	// Generic suggestion
	return fmt.Sprintf("Expected %s but found %s. Review the SQL syntax at this position.", expectedType, tokenType)
}

// SuggestForIncompleteStatement returns a suggestion string explaining what tokens
// or clauses are expected to follow the given SQL keyword. This is used when the