Dedicated Dev UI interface to "log" (and replay/execute?) Hibernate queries (ORM or Search)

[yrodiere]

Description

When developing, It can be quite useful to know what exactly was sent to the database or, in the case of Hibernate Search, to Elasticsearch.

Currently, the only options to do so are through logs.

I think a dedicated Dev UI interface could increase developer joy significantly, especially if we introduce additional features. A few that come to mind (though we may not end up implementing all of them):

• More user-friendly display: e.g. show SQL and bind parameter values next to each other, instead of in separate log lines
• Easy export: "copy" buttons, e.g. for Elasticsearch in a format suitable for pasting into Kibana (see also Kibana/OpenSearch Dashboards dev services #39582)
• Replay: re-run SQL or Elasticsearch requests, possibly after a manual edit, and display results
• Context: show the stack trace that led to a particular statement/request. Or maybe just rely on some OpenTelemetry tracing integration?
• Timing: how long did a given request take?
• Search: filter by endpoint, sort by query time, ... Though that could require rather heavy infrastructure.

Implementation ideas

No response

[quarkus-bot]

/cc @cescoffier (devui), @phillip-kruger (devui)

[gsmet]

That would indeed be awesome.

If you can get the query time there too, I think it could have even more value.

[yrodiere]

See #43618 for the Agroal (SQL) implementation, which will likely be similar