Method generateRecommendations

cmd/gosqlx/cmd/sql_analyzer.go:455–502

generateRecommendations generates actionable recommendations

()

// generateRecommendations generates actionable recommendations
func (a *SQLAnalyzer) generateRecommendations() []string {
	var recommendations []string

	// Get security issues
	securityIssues := 0
	performanceIssues := 0
	for _, issue := range a.Issues {
		switch issue.Category {
		case IssueCategorySecurity:
			securityIssues++
		case IssueCategoryPerformance:
			performanceIssues++
		}
	}

	// Security recommendations
	if securityIssues > 0 {
		recommendations = append(recommendations, "Review and fix security vulnerabilities before production deployment")
	}

	// Performance recommendations
	if a.PerformanceScore < 70 {
		recommendations = append(recommendations, "Consider query optimization techniques to improve performance")
	}

	if a.hasSelectStar {
		recommendations = append(recommendations, "Replace SELECT * with explicit column lists")
	}

	if a.hasCartesian {
		recommendations = append(recommendations, "Review JOIN conditions to avoid cartesian products")
	}

	if a.joinCount > 3 {
		recommendations = append(recommendations, "Consider denormalization or materialized views for complex JOINs")
	}

	// Complexity recommendations
	if a.ComplexityMetrics.OverallComplexity == "HIGH" || a.ComplexityMetrics.OverallComplexity == "VERY_HIGH" {
		recommendations = append(recommendations, "Break down complex queries into simpler components")
	}

	if len(recommendations) == 0 {
		recommendations = append(recommendations, "Query follows good SQL practices")
	}

	return recommendations
}

// buildQueryInfo constructs query metadata from the AST
func (a *SQLAnalyzer) buildQueryInfo(astObj *ast.AST, sql string) QueryInfo {