Explore how Apache Spark SQL simplifies working with complex data formats in streaming ETL pipelines, enhancing data transformation and analysis.