Using Dynamic SQL in BigQuery

Today I want to spotlight an interesting tool, present in multiple database systems, including BigQuery - Dynamic SQL. You might have encountered it before. I used to use it a lot before, but not so much anymore. First, what is Dynamic SQL? We use th...