func GetTidySQL()

in go/utils.go [791:805]

• 13 lines of code
• 5 McCabe index (conditional complexity)

func GetTidySQL(query string) string {
	query = multiLineCommentPattern.ReplaceAllString(query, "")
	query = oneLineCommentPattern.ReplaceAllString(query, "")
	stmt, err := sqlparser.Parse(query)
	if err == nil {
		q := sqlparser.String(stmt)
		// OtherRead represents a DESCRIBE, or EXPLAIN statement.
		// OtherAdmin represents a misc statement that relies on ADMIN privileges.
		if q == "otherread" || q == "otheradmin" || strings.Contains(q, " '$path' ") {
			return strings.Trim(query, " ")
		}
		query = dualPattern.ReplaceAllString(q, "")
	}
	return strings.Trim(query, " ")
}