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

Overview: * Creating custom annotation * Creating component in spring boot * Creation a configuration and middleware in spring boot * Basic of Aspect and usage in spring boot What is Aspect In Spring Boot ? Aspects are cross cutting concerns like logging,security in different layers for the ease of code maintenance . Key Dependency