Can't browser schema with DBeaver

[AllanLeanderRostockHansen]

I can't see/browse the schema (tables, views and such) using DBeaver, but only on connections using this driver... the legacy driver works fine. Querying the data works just fine.

DBeaver version: 22.0.0.202203060510
Clickhouse version: 20.8.12.2

[zhicwu]

I'll take the blame of introducing weird table types in the new driver :p The purpose was to categorize database objects in more categories other than just TABLE and VIEW. I submitted feature request dbeaver/dbeaver#14773 hoping they can be better supported in SQL clients.

@enqueue also suggested to stay with TABLE and VIEW as nicely documented in #778. Apart from that, I noticed the change caused a few issues in other downstream projects like trino.

Anyway, this will be addressed in v0.3.3. Basically, non-standard table types will be move from clickhouse-jdbc to clickhouse-jdbc-ext, a new module for extended JDBC functions. New connection property might be added to enable more table types.

[zhicwu]

This is no longer an issue in main stream database clients.