Worked on the apache/spark repository to optimize Spark SQL V1 command variant handling, specifically improving the ShowColumnsCommand and DescribeTableCommand. The approach preserved resolved entity information, reducing unnecessary catalog lookups and aligning V1 behavior with V2 for greater consistency and future maintainability. Leveraging Scala, SQL, and Spark, the developer validated changes extensively using PlanResolutionSuite and SQLQueryTestSuite to ensure reliability and prevent regressions without impacting user-facing behavior. The work enhanced query planning efficiency and runtime performance for introspection commands, with thorough documentation and strong code-level signals reflecting a deep understanding of Spark SQL planner and catalog resolution processes.