So, I was trying to lower the load of a big DB (Currently using Hibernate and Spring to do the WS), using Spring Projections, but it ended up doing nothing, because the projections to the DB do not work as I tought even when you ask for an ID (For example) it continues to do the SELECT of every column, a solution I found is doins DTO, but this would result in A LOT of DTO, for every result I want to send, and this would take a considerable amount of time, how can I lower the load of a NamedQuery from Hibernate, in a MySQL DB?

Is there anything that works like a Projections for the DB?
Because yes, Projections solved the problem of sending enormous object to the front, (1.4 Million lines), this because I have tables that load other Eagerly, currently changing them to FetchType Lazy to solve this problem, and this would eventually solve it, but, is there anything I can do with this?
Like a complementary thing?

Thanks in advance for your help!