Spring Data JDBC - Support fetching MappedCollections with a filter

Summary

In the current project I am working, I have encountered an issue with the lack of built-in support for MappedCollections used in conjunction with soft-delete functionality in Spring Data JDBC. The potential solutions discussed in the StackOverflow thread linked below seem to require a potential high maintenance effort when upgrading to new versions of Spring Data JDBC.

Note:
I have previously discussed this issue with @schauder and was advised to create this issue.

Abstract Goal

To add support for filtering MappedCollections in Spring Data JDBC, which would allow for more dynamic and controlled data handling, similar to the capabilities provided by Hibernate's @Filter annotation.

Research

As already mentioned, I found a relevant discussion on StackOverflow outlining several potential solutions (StackOverflow Discussion).

Proposed Action

I would like to offer to create a pull request to integrate this functionality into Spring Data JDBC. My preference is for a declarative method akin to Hibernate's @Filter annotation, but I am open to suggestions and willing to explore other viable options.

Next Steps

• I would like the concerned maintainers to chime in and reach an agreement on how to approach this issue.