How to translate sql query to spring boot query with when case and two left join terms?

[Mario tr]

how to translate sql query to spring boot query?

select  ru.id, ru.name,
case when a.r_id is null
then false
else true
end as acc
from ru
left join  a
on ru.id  = a.r_id  and a.a_id = 1
left join b
on b.id  = a.a_id



it doesn't work in this, where is problem:
@Query("select  ru.id, ru.name,
case when a.r_id is null
then false
else true
end as acc
from ru
left join  a
on ru.id  = a.r_id  and a.a_id = 1
left join b
on b.id  = a.a_id")
List<ExamplesDto> getExamples();

[Himai Minh]

How about @Query("select ru.id , ru.name, case when ..... ", nativeQuery=true) ?

Reference:
https://www.baeldung.com/spring-data-jpa-query