Spring Data JPA: @Query when the method name gets silly

interface OrderRepository extends JpaRepository<Order, Long> {

    @Query("""
           select o from Order o
           join fetch o.items
           where o.status = :status and o.placedAt > :since
           """)
    List<Order> recentByStatus(@Param("status") Status status,
                              @Param("since") Instant since);

    @Query(value = "select * from orders where json_extract(meta,'$.vip') = true",
           nativeQuery = true)
    List<Order> vipOrders();
}

The join fetch loads items in the same query,
which is how you avoid N+1 on the list endpoint.