[PP-1] Make the conditions in joins in dynamic queries use Condition objects in the Views module

Problem/Motivation

The conditions in joins in dynamic queries can be and are mostly SQL strings. The conditions can also be a Condition object, like they are in Select queries. The problem is that MongoDB does not support SQL strings.

// MongoDB does not support SQL string conditions.
$connection = \Drupal::database();
$query = $connection->select('node', 'n');
$query->join('inner', 'comment', 'c', '[n].[nid] = [c].[nid]');

In 📌 Make the conditions in joins in dynamic queries use Condition objects Needs review we changed it all modules with the exception of the views module. This issue is about doing the same for the views module.

Proposed resolution

Make the conditions in joins in dynamic queries use Condition objects in the Views module

Merge request link

Remaining tasks

TBD

User interface changes

TBD

API changes

TBD

Data model changes

None

Release notes snippet

TBD