During November 2024, Chenghao contributed to the xupefei/spark repository by developing support for SQL pipe syntax with the WINDOW operator. This feature enables the use of window functions within pipe-based SELECT contexts, allowing data teams to compose more expressive and modular Spark SQL queries. Chenghao enhanced the SQL parser in Scala to recognize the new syntax, implemented robust error handling for invalid usage, and ensured seamless integration with existing Spark SQL capabilities. The work demonstrated depth in data engineering and SQL, focusing on expanding analytical flexibility while maintaining code quality and reliability, though no major bug fixes were addressed.