Write a PostGre Native query to map to POJO

I need a PostGre SQL query written to fetch data from a VIEW. But, I want the result exactly as per my Java Object so I don't have to loop through the result to map each and every value to my object.

More information available here :
https://stackoverflow.com/questions/74375828/getting-array-agg-values-from-single-table-with-different-conditions