Worked on foundational enhancements to materialized views in the def-/materialize repository, focusing on SQL generation and database management using Python and SQL. Delivered support for PARTITION BY in materialized views, allowing users to specify internal storage order through a new configuration option. Refactored the SQL generation logic to consolidate all options into a single WITH clause, addressing a critical issue where multiple WITH blocks could be emitted. Improved the constraint rendering path for correct DDL output and expanded the test suite to ensure correctness and maintainability. These changes reduced the risk of invalid SQL and enabled safer partitioned view usage.