Currently CategoricalArrays are not supported in DuckDB but I think it would be a good idea to do so. I have started a discussion on their Github repo. Would it be possible to add this using the new optional dependencies feature?
Please upvote and contribute to the discussion on GH if this is of interest to you.