How BigQuery Reads Iceberg and Parquet: A Simple Lakehouse Query Walkthrough

I spent time today thinking through a question that sounds simple on the surface, but is actually the core of a modern lakehouse workflow: