가독성을 올리기 위함인가요?

select("*") -> from("TB") -> get() -> result();

이렇게 하면 더 깔끔한가요?..

만약

SELECT
*
FROM TB_MATERIAL_INFO a
  , (SELECT ITEM_ID,COST FROM (SELECT ITEM_ID, COST FROM TB_MATERIAL_COST_INFO ORDER BY REGDT DESC) as Z GROUP BY ITEM_ID ) as b

WHERE a.ITEM_ID = b.ITEM_ID

이런 복잡한 쿼리를 저렇게 만든다고 하면

return $this->db->select('*')
                 ->from('TB_MATERIAL_INFO')
                 ->join('(SELECT ITEM_ID,COST FROM (SELECT ITEM_ID, COST, REGDT FROM TB_MATERIAL_COST_INFO ORDER                                                                                                  
                  BY REGDT DESC) as Z GROUP BY ITEM_ID) as b ','TB_MATERIAL_INFO.ITEM_ID = b.ITEM_ID')
                  ->get()->result_array();

이렇게 해야하잖아요?

join 부분을 더 쪼갤수 있을까요?