Implement `getResultByNodes` in pluggable storage API

### What feature do you want to see added?

https://github.com/jenkinsci/junit-plugin/blob/325d63523b65e598de35f92d8eec44317b2769e9/src/test/java/io/jenkins/plugins/junit/storage/TestResultStorageJunitTest.java#L758

It was implemented in the tests of junit-realtime-test-reporter-plugin in:

https://github.com/jenkinsci/junit-realtime-test-reporter-plugin/pull/36

https://github.com/dcendents/junit-realtime-test-reporter-plugin/blob/1af2f977de6a9cff6f085d0a41201b13960e7f5d/src/test/java/org/jenkinsci/plugins/junitrealtimetestreporter/storage/H2JunitTestResultStorage.java#L613

We need to implement it in the tests here and add coverage and then implement it in junit-sql-storage-plugin

### Upstream changes

_No response_

Start with the getResultByNodes reference at src/test/java/io/jenkins/plugins/junit/storage/TestResultStorageJunitTest.java#L758 and compare it with the implementation in H2JunitTestResultStorage.java#L613 from junit-realtime-test-reporter-plugin. Add the corresponding tests and coverage in junit-plugin, then implement the API in junit-sql-storage-plugin; done means the tests pass and SQL storage supports the operation.

Written by the indexing model from the issue text.