Function extractInValues

backend/plugin/schema/differ.go:1247–1284

extractInValues extracts values from "column IN('A', 'B')" format

(expr string)

// extractInValues extracts values from "column IN('A', 'B')" format
func extractInValues(expr string) []string {
	// Find the IN part
	inIndex := strings.Index(expr, " IN")
	if inIndex == -1 {
		return nil
	}

	// Find the opening parenthesis
	openParen := strings.Index(expr[inIndex:], "(")
	if openParen == -1 {
		return nil
	}
	openParen += inIndex

	// Find the closing parenthesis
	closeParen := strings.LastIndex(expr, ")")
	if closeParen == -1 || closeParen <= openParen {
		return nil
	}

	// Extract the values part
	valuesStr := expr[openParen+1 : closeParen]

	// Split by comma and clean up
	var values []string
	parts := strings.Split(valuesStr, ",")
	for _, part := range parts {
		part = strings.TrimSpace(part)
		// Remove quotes
		if (part[0] == '\'' && part[len(part)-1] == '\'') ||
			(part[0] == '"' && part[len(part)-1] == '"') {
			part = part[1 : len(part)-1]
		}
		values = append(values, part)
	}

	return values
}

// extractAnyValues extracts values from "(column = ANY (ARRAY['A'::text, 'B'::text]))" format
func extractAnyValues(expr string) []string {