**Usage**
Postgres, MySQL, and Oracle support the expression `LEFT JOIN ... ON 1 = 1`, but ClickHouse does not.

It may be possible to replace `LEFT JOIN ... ON 1 = 1` with `CROSS JOIN`, but I want to use the query in the same form for lots of databases.

Please support the expression `LEFT JOIN ... ON 1 = 1`.


**Detailed SQL**
```SQL
CREATE TABLE test
(
    `name` Nullable(String),
    `id` int
)
ENGINE = Log();

insert into test values ('a', 1) ('b', 2) (null, 3);

select * from test t1 left join (select * from test ) t2 on 1 = 1   
-- DB::Exception: Not equi-join ON expression: 1 = 1. No columns in one of equality side.: While processing 1 = 1.
```

NamesAndTypesList columns_added_by_join;
    
    NameToTypeMap left_type_map;
    NameToTypeMap right_type_map;
    
    std::unordered_map<String, String> original_names;
    
    std::unordered_map<String, String> renames;
    VolumePtr tmp_volume;
    std::shared_ptr<StorageJoin> right_storage_join;
    std::shared_ptr<StorageDictionary> right_storage_dictionary;
    std::shared_ptr<DictionaryReader> dictionary_reader;
    Names requiredJoinedNames() const;
    
    ActionsDAGPtr applyKeyConvertToTable(
        const ColumnsWithTypeAndName & cols_src, const NameToTypeMap & type_mapping, NameToNameMap & key_column_rename) const;
    void addKey(const String & left_name, const String & right_name, const ASTPtr & left_ast, const ASTPtr & right_ast = nullptr);
    void assertHasOneOnExpr() const;
    
    template <typename LeftNamesAndTypes, typename RightNamesAndTypes>
    bool inferJoinKeyCommonType(const LeftNamesAndTypes & left, const RightNamesAndTypes & right, bool allow_right);
    NamesAndTypesList correctedColumnsAddedByJoin() const;
public:
    TableJoin() = default;
    TableJoin(const Settings & settings, VolumePtr tmp_volume_);
    
    TableJoin(SizeLimits limits, bool use_nulls, ASTTableJoin::Kind kind, ASTTableJoin::Strictness strictness,