There are multiple methods to work on native queries in spring boot,like using
Query annotation @ResultSet mapping annotation to map non entity Dtos,
as query complexity increases code readability also decreases,
i have preferred to use simple Solution and to map result to Dto for native
query, for better