@Value(staticConstructor = "of")
public class TotalsDto {
    LocalDate date;
    long totals;
    long totalPerCategory;
    int categoryId;
    String categoryName;
}

@Repository
public interface TotalsRepository extends JpaRepository<TotalsDto, Integer> {

    @Query(value = "SELECT ...", nativeQuery = true)
    List<TotalsDto> getTotals(params...);
}

SELECT my.package.TotalsDto.of(column1, subqueryResult1, subqueryResult2...)