Is there any way or some kind of extension which will generate JOIN query for default Spring Data JDBC repositories?

For example:

public class Root {

    private @Id Long id;
    private String name;

    @MappedCollection(idColumn = "root_id")
    private Set<Child> list = new HashSet<>();
}

public class Child {

    private @Id Long id;
    private Long rootId;
    private String element;
}

This will generate two separate queries for findAllById() method:

SELECT * FROM Root WHERE id = :id
SELECT * FROM Child WHERE rootId = :id

But I would like to have simple left join, something like:

SELECT r.id, r.name, c.id, c.rootId, c.element FROM Root AS r
LEFT JOIN Child AS c ON r.id = c.root_id
WHERE r.id = :id

Is that possible somehow?