Would it be more performant or efficient to write pure Snowql queries in Panther instead of relying on a translation layer (standard SQL)?
No, there would not be any better performance as Snowflake was designed to process standard SQL natively without translation.