Support for traceparent Tag in SQL Query Comments with Query Tags Feature

[Kashish3009]

Is your proposal related to a problem?

We have a requirement from an enterprise customer who is trying to set up OpenTelemetry Integration between Hasura and other 3rd party observability tools like pganalyze, New Relic etc.. They need to include the traceparent query tag in the SQL query comments when the Query Tags feature is enabled. Currently, this tag is not emitted in the query-log generated SQL.

Example SQL:

SELECT coalesce(json_agg("root"), '[]') AS "root"
FROM (SELECT row_to_json((SELECT "_e" FROM
(SELECT "_root.base"."MediaTypeId" AS "MediaTypeId",
"_root.base"."Milliseconds" AS "Milliseconds",
"_root.base"."Name" AS "Name",
"_root.or.Album"."Album" AS "Album") AS "_e"))
AS "root"
FROM (SELECT * FROM "public"."Track"
WHERE ('true') LIMIT 10 OFFSET 1) AS "_root.base"
LEFT OUTER JOIN LATERAL
(SELECT row_to_json((SELECT "_e" FROM
(SELECT "_root.or.Album.base"."Title" AS "Title")
AS "_e")) AS "Album"
FROM (SELECT * FROM "public"."Album"
WHERE (("_root.base"."AlbumId") = ("AlbumId"))
LIMIT 1) AS "_root.or.Album.base")
AS "_root.or.Album" ON ('true')) AS "_root"
/* field_name='Track', operation_name='getTrack', parameterized_query_hash='9c0a5f0bd1b1c709e3a111d5f518ceebe7e1277e', request_id='9e95a0d5-987a-4a0e-bf4c-9eca07ae7109' */

Based on our internal review and pganalyze documentation, it appears that the SQL comments generated by Hasura do not include the traceparent tag, which is needed for the OpenTelemetry integration.

Describe the solution you'd like

Add support for the traceparent tag in the SQL query comments when the Query Tags feature is enabled.

Describe alternatives you've considered

No other alternatives are available till date.