I just started using BigQuery, and I have no idea how people tolerate it. Can't delete a column. Can't rename a column. Can't change a datatype of a column. If I added a wrong column, I have to recreate the whole table (via SELECT * EXCEPT).