SELECT
Choose which columns (or derived expressions) to return. The simplest clause in SQL, and the one most likely to silently break a downstream consumer. SELECT * looks harmless in a notebook and becomes a footgun in production.
Syntax #
sql
SELECT col_1, col_2, expr AS alias
FROM table_name;Example #
Loading SQL editor...
Warning
**SELECT in production is a slow-motion break.* When the source table adds, renames, or reorders columns, every downstream view, report, and consumer reading by position drifts silently. Enumerate columns explicitly in any query that persists (notebooks are fine).