TYPO3 Core

For anyone else having the same problem:

At least an unclean INNER JOIN with null as $condition and any existing alias as $fromAlias can be used. It's not clean, but it is better than nothing.

Why "unclean" you ask?

In MariaDB, CROSS JOIN is a syntactic equivalent to INNER JOIN (they can replace each other). In standard SQL, they are not equivalent. INNER JOIN is used with an ON clause, CROSS JOIN is used otherwise.

Source: https://mariadb.com/kb/en/join-syntax/ (emphasis mine)

TYPO3 will not implement CROSS JOIN on it's own. We would end in nearly completly
writing the QueryBuilder on our own then. That said, you should headover to the
Doctrine DBAL repository and suggest that to Doctrine first.

To be honest, I doubt it will be implemented there either.

On our side, the maintenance burdon would drasticilly increase
due to having "cloning" final classes, maintaining own state,
implementig all the query building and keeping it up2date.

Doctrine strives to implement only stuff which is cross-dbmns compatible for
all supported database systems.

With the current solution your only way is to use the `*join()` methods or
use from() multiple times.

Basically, you can use an innerJoin() just fine without a join condition,
which acts exactly the same as a cross join (for mariadb, mysql and sqlite)
. CROSS JOIN is just a simplyfied solution there. However, PostgreSQL needs
a special treatment thus you need a conditional condition based on the
connection database platform and use a `ON true` condition.

I'm going to reject that feature for now and we will see if doctrine
implements that if you asked them gently. If you want to discuss further
head over to reopen the issue.