As OneAgent SDK does allow us to trace queues and messages, can someone help with custom instrumentation which we can use to measure queue depth.
Queue depth is by nature a metric. Thus you need to push metric value. This is not available using OneAgent SDK, since it's about tracing only.
You have several options here
If you need to push the metric from your code directly, I'd recommend using the OpenTelemetry approach.