**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.
```

sample_block_with_columns_to_add = right_table_keys = materializeBlock(right_sample_block);
    }
    LOG_TRACE(log, "Columns to add: [{}], required right [{}]",
              sample_block_with_columns_to_add.dumpStructure(), fmt::join(required_right_keys.getNames(), ", "));
    {
        std::vector<String> log_text;
        for (const auto & clause : table_join->getClauses())
            log_text.push_back(clause.formatDebug());
        LOG_TRACE(log, "Joining on: {}", fmt::join(log_text, " | "));
    }
    JoinCommon::removeLowCardinalityInplace(right_table_keys);
    initRightBlockStructure(data->sample_block);
    JoinCommon::createMissedColumns(sample_block_with_columns_to_add);
    if (nullable_right_side)
        JoinCommon::convertColumnsToNullable(sample_block_with_columns_to_add);
    size_t disjuncts_num = table_join->getClauses().size();
    data->maps.resize(disjuncts_num);
    key_sizes.reserve(disjuncts_num);
    for (const auto & clause : table_join->getClauses())
    {
        const auto & key_names_right = clause.key_names_right;
        ColumnRawPtrs key_columns = JoinCommon::extractKeysForJoin(right_table_keys, key_names_right);
        if (table_join->getDictionaryReader())
        {
            assert(disjuncts_num == 1);
            LOG_DEBUG(log, "Performing join over dict");
            data->type = Type::DICT;
            data->maps.resize(disjuncts_num);
            std::get<MapsOne>(data->maps[0]).create(Type::DICT);
            key_sizes.resize(1);