Worked on expanding ClickHouse dialect support within the sqlglot repository, focusing on enabling correct transpilation of the ArrayDistinct function. The approach involved implementing support for ArrayDistinct in the transpiler using Python and SQL, ensuring that ClickHouse-specific queries could be accurately converted. Comprehensive tests were added to validate the new functionality and provide regression protection, reflecting a methodical approach to quality assurance. A targeted bug fix was also applied to address issues with ArrayDistinct transpilation, further improving reliability. This work enhanced query portability for users integrating ClickHouse with sqlglot, demonstrating attention to both feature development and robust testing practices.