That's correct, and I absolutely love it. If I move to a new role where BigQuery is not the data warehouse of choice, I think this will be the thing I'll miss most.
Snowflake also allows trailing commas :)
It's nice when bigquery and python together for data analysis that little things like that are congruent