Feature Request: Do not rely on Hive paths for partition values, use ducklake_file_partition_value

[aersam]

I* tried to create a python package that converts delta to ducklake - you know, I really like ducklake! It works pretty well, but this one is a blocker

ducklake extension seems to rely on Hive paths for partition values, which is very strange given that there is a nice table in ducklake, ducklake_file_partition_value. instead of relying on old Hive Paths, why not just use the nice, much more flexible table there already is? seem to be related somewhat to #252 , but I think you could still support adding hive-style tables, you anyway should update ducklake_file_partition_value I guess. Also as I understand, Hive paths are rather an anti-pattern for modern object storages because of performance - so we should not rely on it.

Also linking #35, since this one will block Delta pretty much. In practice, many delta tables are created by databricks, which does not default to Hive anymore.

*I=me and claude.

[aersam]

Maybe related: #1195