Full outer join not working

[poofeg]

Describe the bug
The incorrect syntax of the full join is generated: "FULL LEFT OUTER JOIN".

To Reproduce

from clickhouse_sqlalchemy.drivers.base import clickhouse_dialect
from clickhouse_sqlalchemy.ext.declarative import ClickHouseDeclarativeMeta
from sqlalchemy import Integer, Column, select
from sqlalchemy.orm import declarative_base

Base = declarative_base(metaclass=ClickHouseDeclarativeMeta)


class Left(Base):
    __tablename__ = 'left_table'
    id = Column(Integer, primary_key=True)


class Right(Base):
    __tablename__ = 'right_table'
    id = Column(Integer, primary_key=True)


stmt = select(Left).outerjoin(Right, Left.id == Right.id, full=True)
compiled = stmt.compile(dialect=clickhouse_dialect)
print(compiled)

SELECT left_table.id 
FROM left_table FULL LEFT OUTER JOIN right_table ON left_table.id = right_table.id

Expected behavior

SELECT left_table.id 
FROM left_table FULL OUTER JOIN right_table ON left_table.id = right_table.id

Versions

• clickhouse-sqlalchemy 0.2.1
• Python 3.10.6

[poofeg]

Temporary fix:

class FixedClickHouseSQLCompiler(ClickHouseSQLCompiler):
    def visit_join(self, join: Any, asfrom: bool = False, **kwargs: Any) -> str:
        return super().visit_join(join, asfrom, **kwargs).replace('FULL LEFT OUTER JOIN', 'FULL OUTER JOIN')


class FixedClickHouseDialect(ClickHouseDialect):
    statement_compiler = FixedClickHouseSQLCompiler


clickhouse_dialect = FixedClickHouseDialect()