Using Common Table Expressions (CTEs) in Snowflake for Complex Inserts: A Simplified Approach to Large-Scale Data Ingestion.