Here's another cool use case by @mentin:

https://medium.com/@mentin/bigquery-talking-to-postgresql-f6a3990f4184#c491-76eca898f80a

But yes, a key use case for dynamic SQL is migration from other data warehouses