Add support of @Sql in tests of @ApplicationModuleListener

Could you please add support of sql scripts in tests of module listeners (org.springframework.modulith.events.ApplicationModuleListener)?

I. e. this:

    @Test
    @Sql("classpath:sql/some-inserts.sql", "classpath:sql/file-abcd.sql")

do inserts rows in one transaction, but this:

    @ApplicationModuleListener
    fun on(event: SomeCoolStuffHappened) {

creates a new txn and does not see inserts from @Sql. W/o this support one need to mock a bunch of stuff.

Thanks in advance!

Start by tracing how @ApplicationModuleListener test execution manages transactions and how Spring's @Sql scripts are applied. Reproduce the example with inserts from both SQL files, then add a regression test showing that the listener's new transaction can see those rows. Done means @Sql-backed listener tests work without mocking the involved components.