#одна колонка - по почте фильтрация - смотрим как события
SELECT *
FROM
  (SELECT backend."id" AS "backend_id",
          backend.id AS "backend_abc",
          to_timestamp(to_char(backend."CreateDate"::TIMESTAMP WITH TIME ZONE AT TIME ZONE 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::TIMESTAMP WITHOUT TIME ZONE AS "backend_CreateDate",
                                                                                                                                                                                                    to_timestamp(to_char(backend."UpdateDate"::TIMESTAMP WITH TIME ZONE AT TIME ZONE 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::TIMESTAMP WITHOUT TIME ZONE AS "backend_UpdateDate",
                                                                                                                                                                                                                                                                                                                                                                                              backend."ActionName" AS "backend_ActionName",

         ,...,

     (SELECT MAX(CASE
                     WHEN "ColumnName" = 'new_colw' THEN "ColumnValue"
                     ELSE NULL
                 END)
      FROM backendext
      WHERE "BackendId" = backend.id
      GROUP BY "BackendId") AS "backend_new_colw",
        ,...,
                                                                                                                                                                                                                                                                                                                                                                                              screens."Name" AS "screens_Name",
                                                                                                                                                                                                                                                                                                                                                                                              ,....,                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                objects."Testval" AS "objects_Testval",

    ,...,

     (SELECT MAX(CASE
                     WHEN "ColumnName" = 'НоваяКолонка1_357624f4a4' THEN "ColumnValue"
                     ELSE NULL
                 END)
      FROM backendext
      WHERE "BackendId" = backend.id
      GROUP BY "BackendId") AS "backend_НоваяКолонка1_357624f4a4"
   FROM backend
   LEFT JOIN objects ON objects.id = backend."ObjectId"
   LEFT JOIN statuses ON statuses.id = backend."StatusId"
   LEFT JOIN users ON users.id = backend."Responsibleid"
   LEFT JOIN screens ON screens.id = backend."ScreenId") x
WHERE "backend_ApplicationId" = 672
  AND ("objects_Email"='nzulfigarov@gmail.com')