Note

Medium Risk
Changes core metadata queries and type filtering logic used by client tooling; incorrect mapping or filter predicates could hide tables or misclassify types across ClickHouse versions.

Overview
Improves DatabaseMetaData table typing and filtering in JDBC v2. Adds a new MATERIALIZED VIEW table type and introduces an explicit ENGINE_TO_TABLE_TYPE mapping so getTables() reports consistent JDBC TABLE_TYPE values for known ClickHouse engines (including remote/external engines), with sensible defaults for unknown engines.

getTables() is reworked to filter by requested JDBC table types by translating them into engine predicates (plus special handling for System*/Async* engines and temporary tables), and it now uses PreparedStatement + a DetachedResultSet mutator to post-process engine names into JDBC table types. getTableTypes() is also switched to a parameterized array-based query.

Integration tests are expanded to (1) assert every engine in system.table_engines is mapped or covered by the system-engine prefixes, and (2) create representative objects (table/view/materialized view/remote/dictionary/etc.) to validate both unfiltered and type-filtered getTables() behavior and the full set returned by getTableTypes().

^{Written by Cursor Bugbot for commit 59f87e9. This will update automatically on new commits. Configure here.}