The fundamental requirements of DBMS so it can be a DuckLake catalog are the following:
1. It must support primary keys
2. It must support basic data types (INTEGER,VARCHAR,TIMESTAMP)
3. ACID
There are ofc some quirks from the SQL supported on each DBMS. Hence, the DuckLake extension from DuckDB currently supports DuckDB, SQLite, Postgres, DuckDB + Quack and MySQL. With MySQL being in a rather experimental state.
There are ofc some quirks from the SQL supported on each DBMS. Hence, the DuckLake extension from DuckDB currently supports DuckDB, SQLite, Postgres, DuckDB + Quack and MySQL. With MySQL being in a rather experimental state.
Disclaimer: I'm the lead developer in DuckLake.