Motivation

https://en.wikipedia.org/wiki/Join_(SQL)#Cross_join

Proposed Solutions

.join(JoinType::CrossJoin, tbl_ref, condition)

.join_lateral(JoinType::CrossJoin, query, alias, condition)

Additional Information

It often helps to be more explicit about your intentions.