Worked on the tobymao/sqlglot repository to enhance PostgreSQL array containment support by implementing the ArrayContainedBy expression, which enables accurate handling of the contained-by operator in SQL queries. Focused on ensuring correct SQL generation and validation for array containment checks, the work addressed operator direction preservation to maintain semantic accuracy, particularly in edge cases. Utilized Python and SQL to update core expression logic and reinforce robust testing practices. Collaborated closely with peers on design and code review, contributing to improved code quality. This feature reduces misgenerated SQL and errors for users relying on PostgreSQL arrays, deepening the library’s correctness.