Before we get into the demonstration, let’s go over the differences between duplicate and reference queries. A duplicate query is analogous but not the same as copying a query. A duplicate query has no lasting relationship with the original query. Once a query has been duplicated, it is a new and separate query with independent copies of the data and steps that made up the original query. Deleting or changing the original query’s applied steps will have no effect on the duplicate. This is not the case for a reference query. A reference query has a relationship with the original as that of a child and parent in object-oriented programming. The reference query inherits the data and steps of the original by maintaining a reference to the original, not by making copies of them. Meaning any changes to the original or parent query will be reflected in the child reference query.

In this course, I want to look at query transformations and see how those transformations are reflected when duplicating and referencing queries.