In BigQuery you can specify columns to include as well as exclude. For example: select s.*, t.* except (s.foo, s.bar, t.blah) from s, t where ...

In BigQuery you can specify columns to include as well as exclude. For example: select s.*, t.* except (s.foo, s.bar, t.blah) from s, t where ... I've found this extremely handy for avoiding duplicate column names when joining tables. For example, trying to join two tables that both have an "id" column can be really tedious without this syntax. How would your syntax achieve that?