Function isPostgreSQLInAnyEquivalent

backend/plugin/schema/differ.go:1174–1204

isPostgreSQLInAnyEquivalent checks if expr1 contains IN syntax that PostgreSQL would normalize to ANY syntax in expr2

(expr1, expr2 string)

// isPostgreSQLInAnyEquivalent checks if expr1 contains IN syntax that PostgreSQL would normalize to ANY syntax in expr2
func isPostgreSQLInAnyEquivalent(expr1, expr2 string) bool {
	// Clean up expressions for comparison
	expr1 = strings.TrimSpace(expr1)
	expr2 = strings.TrimSpace(expr2)

	// Handle common PostgreSQL transformations:
	// "column IN ('A', 'B')" -> "(column = ANY (ARRAY['A'::text, 'B'::text]))"

	// Very basic pattern matching for this specific case
	// Look for patterns like "column IN(...)" in expr1 and "column = ANY (ARRAY[...])" in expr2
	if strings.Contains(expr1, " IN(") || strings.Contains(expr1, " IN (") {
		// Extract the column name and values from IN expression
		if strings.Contains(expr2, " = ANY (ARRAY[") && strings.Contains(expr2, "::text") {
			// This is a simplified check - for a production system, you'd want more robust parsing
			// For now, just check if both expressions contain the same column name
			inParts := strings.Split(expr1, " IN")
			if len(inParts) >= 2 {
				column1 := strings.TrimSpace(inParts[0])
				// Remove any leading parentheses from column name
				column1 = strings.TrimPrefix(column1, "(")

				if strings.HasPrefix(expr2, "("+column1+" = ANY") || strings.HasPrefix(expr2, column1+" = ANY") {
					// Extract values from both expressions and compare
					return compareInVsAnyValues(expr1, expr2)
				}
			}
		}
	}

	return false
}

// compareInVsAnyValues compares the values in IN syntax vs ANY syntax
func compareInVsAnyValues(inExpr, anyExpr string) bool {