Advent of Code, a popular annual programming challenge, features algorithmic puzzles that are typically tackled using general-purpose languages. However, ClickHouse, a vectorized query engine, showcased its capabilities by solving the 2025 puzzles using only its SQL. By leveraging ClickHouse's extensive library of functions, including Recursive CTEs, array functions, and polygon functions, the team managed to overcome the inherent limitations of SQL in handling complex state management and data structures. The challenge imposed strict rules, such as using pure ClickHouse SQL without preprocessing inputs or using UDFs. Solutions demonstrated the database's ability to handle tasks traditionally thought to be impossible in SQL, transforming them into manageable data problems. Despite not being as computationally optimal as solutions in languages like Rust or Python, the ClickHouse queries delivered accurate results, underscoring the engine's versatility and power in complex problem-solving scenarios.