Method handleCompletion

pkg/lsp/handler.go:661–701

handleCompletion provides completion suggestions for SQL keywords and snippets. This handler implements intelligent auto-completion that helps users write SQL faster with less typing. It provides context-aware suggestions based on the current cursor position and partial input. Features: - 100+ SQL

(params json.RawMessage)

//   - Empty list if no matches or document not found
//   - IsIncomplete=true if results were truncated
func (h *Handler) handleCompletion(params json.RawMessage) (*CompletionList, error) {
	var p CompletionParams
	if err := json.Unmarshal(params, &p); err != nil {
		return nil, err
	}

	doc, ok := h.server.Documents().Get(p.TextDocument.URI)
	if !ok {
		return &CompletionList{Items: []CompletionItem{}}, nil
	}

	// Get partial word at position for filtering
	word := doc.GetWordAtPosition(p.Position)
	prefix := strings.ToUpper(word)
	lowerPrefix := strings.ToLower(word)

	// Build completion items - keywords first
	items := []CompletionItem{}
	for _, kw := range sqlKeywords {
		if prefix == "" || strings.HasPrefix(strings.ToUpper(kw.Label), prefix) {
			items = append(items, kw)
		}
	}

	// Add snippets (match on lowercase prefix for snippet shortcuts)
	for _, snippet := range sqlSnippets {
		if lowerPrefix == "" || strings.HasPrefix(strings.ToLower(snippet.Label), lowerPrefix) {
			items = append(items, snippet)
		}
	}

	// Limit results
	if len(items) > 100 {
		items = items[:100]
	}

	return &CompletionList{
		IsIncomplete: len(items) >= 100,
		Items:        items,
	}, nil
}

// handleFormatting formats the SQL document with intelligent indentation.
//