sql to orm

SELECT
  PA.ID,
  PA.AREA,
  PA.CITY,
  PA.STREET,
  PA.HOUSE,
  PA.APARTAMENT,
  PA.CODE_ACCOUNT,
  --   OBF.ADRESS_FIAS,
  --   OBF.KADASTR_NUMBER,
  --   OBF.FIAS,
  PA.FIO,
  PA.CONTRACT_NAME,
  PA.HOUSE_TYPE,
  PA.DATE_FROM,
  PA.DATE_BY,
  PA.DATE_CREATE,
  PA.DATE_UPDATE,
  PA.USER_ID,
  PA.CONTRACT_ID,
  PA.RKC,
  B1.SALDO_K,
  B1.KOL_MONTH,
  B1.PAYMENT,
  B1.RECALC,
  B1.ACCRUAL,
  TO_CHAR(B1.BALANCE_DATE, 'yyyy-mm-dd') AS BALANCE_DATE
FROM
  PERSONAL_ACCOUNT PA
  LEFT JOIN (
    SELECT
      B.ACCOUNT_ID,
      B.BALANCE_DATE,
      B.SALDO_N,
      B.ACCRUAL,
      B.RECALC,
      B.PAYMENT,
      CASE WHEN B.ACCRUAL <> 0 THEN ROUND(B.SALDO_N / B.ACCRUAL, 0) ELSE 0 END KOL_MONTH,
      B.SALDO_K
    FROM
      BALANCE B
      JOIN (
        SELECT
          ACCOUNT_ID,
          MAX(BALANCE_DATE) AS MAX_BALANCE_DATE
        FROM
          BALANCE
        GROUP BY
          ACCOUNT_ID
      ) MAX_BALANCE_DATE ON B.ACCOUNT_ID = MAX_BALANCE_DATE.ACCOUNT_ID
      AND B.BALANCE_DATE = MAX_BALANCE_DATE.MAX_BALANCE_DATE
  ) B1 ON PA.ID = B1.ACCOUNT_ID
LIMIT 5