Issue #2949939 by azinck, cgoffin, AlexKirienko, Grimreaper, SpadXIII, joseph.olstad, jecunningham2281, dewalt, andypost: The latest_revision ViewsFilter has poor performance

Issue #2628130 by Krzysztof Domański, raman.b, Lendude, kishor_kolekar, cgoffin, lamp5, cmarti, alexpott, catch, andypost: SQL error on revision export from view

Revert "Issue #2628130 by Krzysztof Domański, raman.b, kishor_kolekar, cgoffin, lamp5, cmarti, Lendude, joseph.olstad, elgandoz, andypost, tanubansal, acrazyanimal, wmike7, alexpott: SQL error on revision export from view"

This reverts commit 7baff21a.

Issue #2628130 by Krzysztof Domański, raman.b, kishor_kolekar, cgoffin, lamp5, cmarti, Lendude, joseph.olstad, elgandoz, andypost, tanubansal, acrazyanimal, wmike7, alexpott: SQL error on revision export from view

Issue #3072076 by JordanDukart, logickal, gabesullice, cgoffin, patrickfweston, Wim Leers, alexpott, scuba_fly, larowlan, nehiryeli, xjm, borisson_: JSON:API returns a CacheableResponseInterface instance for non-cacheable methods; causes unnecessary exceptions

Issue #3016814 by jhedstrom, peximo, alexpott, jungle, scuba_fly, mr.baileys, FrancescoQ, cgoffin, Petr Illek, fabio84: Don't trigger hook_file_download when no file is requested