Issue #3130655 by daffie, andypost, Beakerboy, ravi.shankar, alexpott, mradcliffe, Lendude: Deprecate creating an instance of the class Drupal\Core\Database\Query\Condition with the new keyword

Issue #2824935 by idebr, mfernea, Deepak Goyal, pfrenssen, longwave, hgunicamp, jofitz, andypost, daffie: Fix Squiz.ControlStructures.SwitchDeclaration coding standard

Issue #2986452 by alexpott, andypost, kostyashupenko, daffie, kriboogh, larowlan, kristiaanvandeneynde, chrisrockwell, bleen, nevergone: Database reserved keywords need to be quoted as per the ANSI standard. Also resolves https://www.drupal.org/project/drupal/issues/371

Issue #2580265 by FeyP, jcisio, s_leu, Berdir, tstoeckler: entity query nested conditions must use LEFT joins when any of the parent condition groups is using OR

Issue #2665992 by alexpott, klausi, heykarthikwithu, xjm, tstoeckler: @file is not required for classes, interfaces and traits

Issue #2515018 by joshi.rohit100, sdstyles, joelpittet: Lowercase the instances of camelcase'd instanceOf in core for consistency

This reverts commit f57b659d.

Issue #2068655 by Berdir, chx, martin107, longwave, webflo, damiankloip, lokapujya, JacobSanford: Entity fields do not support case sensitive queries

Issue #2038707 by chx, rlmumford, yanniboi, andrewbelcher: Entity query sql backend limits storage controllers changes in contrib.