4 ms·
SELECT * EXCEPT(col_name) next please.
by SigmundA 11mo ago
SELECT * EXCEPT(col_name) next please.
- azurezyq 11mo agoBigQuery has it! https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select_except https://docs.cloud.google.com/bigquery/docs/reference/standa...
- SigmundA 11mo agoYes it needs to be in the standard though.
- 1718627440 11mo agoThat might be nice for manual experimentation, but for application use, this seems brittle compared to specifying the columns you really want to have and process.
- petereisentraut 11mo agoThis was also discussed at the last SQL WG meeting but was postponed for further refinement. But it’s likely to be added soon.