sqlOperations from private to public

[kazu697]

Summary

In nrpq.go, where the Postgres DatastoreSegment is being retrieved, the execution of the Truncate query in Postgres is displayed as "Other." The reason for this is that the query named "Truncate" is not registered in sqlOperations within sqlparse.go.

go-agent/v3/newrelic/sqlparse/sqlparse.go

Lines 27 to 42 in 046b4fc

	sqlOperations = map[string]*regexp.Regexp{
	"select": regexp.MustCompile(`(?is)^.*\sfrom` + tablePattern),
	"delete": regexp.MustCompile(`(?is)^.*\sfrom` + tablePattern),
	"insert": regexp.MustCompile(`(?is)^.*\sinto?` + tablePattern),
	"update": updateRegex,
	"call": nil,
	"create": nil,
	"drop": nil,
	"show": nil,
	"set": nil,
	"exec": nil,
	"execute": nil,
	"alter": nil,
	"commit": nil,
	"rollback": nil,
	}

Desired Behaviour

it would allow the addition of keys within the project code, thereby enabling the display of queries such as Truncate in DatastoreSegment.

Possible Solution

I would like to propose a change in the visibility of sqlOperations from private to public.