fix(knex): nested queries result in wrong span names

[nachogiljaldo]

Fixes #1535

Which problem is this PR solving?

• instrumentation-knex generates wrong span names when the knex query has a nested query in its first element

Short description of the changes

• consider the possibility of nested queries and add the corresponding unit tests to deal with it

[linux-foundation-easycla]

The committers listed above are authorized under a signed CLA.

• ✅ login: nachogiljaldo / name: Jose Ignacio Gil Jaldo (1caddef, 4202d5b, 3997cf0, a2dc961, a525478, 45b6fba, c17caf0)
• ✅ login: pichlermarc / name: Marc Pichler (445fdbb)
• ✅ login: blumamir / name: Amir Blum (3cfc4a7, 50c395b)

[dyladan]

Generally looks good to me but I would prefer if we could remove the any in favor of a more descriptive type

[codecov]

Codecov Report

Merging #1537 (50c395b) into main (3f2bfe8) will increase coverage by 0.00%.
The diff coverage is 100.00%.

Additional details and impacted files

@@           Coverage Diff           @@
##             main    #1537   +/-   ##
=======================================
  Coverage   91.37%   91.38%           
=======================================
  Files         127      127           
  Lines        6345     6350    +5     
  Branches     1274     1275    +1     
=======================================
+ Hits         5798     5803    +5     
  Misses        547      547           

Files Changed	Coverage Δ
...emetry-instrumentation-knex/src/instrumentation.ts	98.78% <100.00%> (ø)
...de/opentelemetry-instrumentation-knex/src/utils.ts	90.24% <100.00%> (+1.35%)	⬆️

[nachogiljaldo]

Hey @rauno56 I believe your review is requested in order to merge this. Any chance you can have a look in the near future?

[nachogiljaldo]

@rauno56 any chance you have a look at this?

[haddasbronfman]

Hi. @rauno56 is no longer / very rarely working on this library.
But you need only one approval (from an approver or from the code owner).
I would ask @dyladan or @pichlermarc to resolve the issue above and then any other approver can merge this for you.

[dyladan]

I'm out of office until Tuesday sorry

[nachogiljaldo]

@blumamir I am afraid I can't merge because @rauno56 is still requested and I can't remove him. Anything you can do?

[blumamir]

@blumamir I am afraid I can't merge because @rauno56 is still requested and I can't remove him. Anything you can do?

It's ok I merged it 👍