[Feature]: Investigate using ResponseModel DTOs directly in database queries to eliminate intermediate Entity DTO mapping

[PapLabros]

Describe the solution you'd like

We should investigate the feasibility of retrieving data directly as ResponseModel DTOs from the database when handling GET endpoints, instead of first loading Entity DTOs and then mapping them to ResponseModel DTOs.

This change would allow the database (via ORM projection) to directly project query results into ResponseModel DTOs, eliminating the need for AutoMapper during GET requests and bypassing property getter logic in Entity DTOs — which often introduces unnecessary computation.

If feasible, this approach could significantly improve performance, reduce memory usage, and simplify the data retrieval pipeline.

Alternatives you've considered

No response

Additional context

No response