Default behvior of sqlOperationName does not ignore comments

[rfhold]

Our spans all have db.operation.name="--" because our queries have comments in the beginning, I would expect the the actual operation to be listed instead.

an example of the span attributes

[
  {
    "value": "--",
    "key": "db.operation.name"
  },
  {
    "value": "-- name: GetFoo :one\nSELECT id FROM bar.foo WHERE id = $1",
    "key": "db.query.text"
  }
]

[costela]

This is intentional: the default logic for extracting the operation name is kept simple because it can be arbitrarily complex and paying its performance cost per default may not make sense for most users.
You can use WithSpanNameFunc to provide a function that extracts your particular naming format.

We could also consider adding helpers for the most common comment syntaxes out there.

[rfhold]

Where would you want those helpers to live? We are using sqlc following its format, I could add it pretty quick