Understanding Tables with Unapplied Upsert Data in BigQuery: A Practical Guide to Overcoming Query Limitations