The passage of time

BigQuery date partitioned tables can limit the data scan by partitions to help keep the query cost low and improve query performance. However, Google's documents do not give much clue how to use partitioned tables to create views that support partition queries. I did some research and found the way to do it, even with views that are created from joining partitioned tables.