From corpus testing against SQLGlot's 1,278 queries (14 PARTIAL results):
SELECT * EXCEPT (a, b) — exclude columns from wildcard
SELECT * REPLACE (expr AS col) — replace column in wildcard expansion
SELECT t.* EXCEPT (col) — scoped wildcard exclusion
This is BigQuery/Spanner syntax, not standard MySQL/PostgreSQL. Low priority unless BigQuery compatibility is needed.
From corpus testing against SQLGlot's 1,278 queries (14 PARTIAL results):
SELECT * EXCEPT (a, b)— exclude columns from wildcardSELECT * REPLACE (expr AS col)— replace column in wildcard expansionSELECT t.* EXCEPT (col)— scoped wildcard exclusionThis is BigQuery/Spanner syntax, not standard MySQL/PostgreSQL. Low priority unless BigQuery compatibility is needed.