Is it possible to have `ALLOW_FIELD_ADDITION` parameter on a query level.
For example if we have a query like this
INSERT INTO TABLE_1 WITH ALLOW_FIELD_ADDITION=TRUE
SELECT * FROM TABLE_1_stage;
So here in this case if TABLE_1_stage has some extra columns than using `ALLOW_FIELD_ADDITION` feature will help in incrementally loading table without any worry of errors related to schema change.
Reviewing Modifying Tables Schemas, to signal that the data you are appending contains new columns, you should set the --schema_update_option flag to ALLOW FIELD ADDITION.
Additionally, as an alternative solution, here is an StackOverflow solution that provides a different way to add fields to a schema.