Worked on the tobymao/sqlglot project to enhance optimizer-level support for SQL function compatibility across dialects. Focused on database optimization by implementing metadata annotation for the REPLACE function within the MySQL dialect, ensuring accurate recognition and translation during query planning. Extended this approach by adding cross-dialect annotation support for the REPEAT function, allowing the optimizer to handle this function consistently across multiple SQL dialects. Developed comprehensive tests to validate the behavior of the REPLACE function, providing regression protection and correctness. Utilized Python and SQL to deliver these features, improving translation fidelity and reducing friction for MySQL users in multi-dialect environments.