Updating with a subquery

  db.execute(sql`
      UPDATE feeds AS f
        SET "lastPublishedAt" = (
          SELECT MAX(fi."publishedAt")
          FROM "feedItems" AS fi
          WHERE fi."feedId" = f.id
        );`);