Add support for STATEMENT_INSPECTOR in Hibernate ORM

[llongeri]

Description

Add support to configure a org.hibernate.resource.jdbc.spi.StatementInspector
which is defined in org.hibernate.cfg.AvailableSettings.STATEMENT_INSPECTOR

So that it could be added in application.properties as:
quarkus.hibernate-orm.session_factory.statement_inspector=org.example.MyStatementInspector
or
quarkus.hibernate-orm.other.session_factory.statement_inspector=org.example.MyStatementInspector

The stament inspector instantiated should be a managed bean.

Implementation ideas

No response

[quarkus-bot]

/cc @Sanne, @gsmet, @yrodiere

[Sanne]

Thanks for raising this!

I'm in favour of adding such a feature, but I wonder if we could omit the configuration property: especially as it's a managed bean, we could wire it to Hibernate during bootstrap using @PersistenceUnitExtension

Similarly to how we do Interceptors:

• https://quarkus.io/guides/hibernate-orm#interceptors

What would you think of it? I haven't tried it though, it would need a POC first to see if I'm missing something.

[llongeri]

using @PersistenceUnitExtension is a much better solution.
I will try to make a POC.

[yrodiere]

For anyone ending up here and not wanting to contribute the feature, there is a workaround that I just used in integration tests (#30392): rely on quarkus.hibernate-orm.unsupported-properties, e.g.:

quarkus.hibernate-orm.unsupported-properties."hibernate.session_factory.statement_inspector" = com.acme.MyInspector