ydb/yql/essentials/docs/en/syntax/select/without.md

WITHOUT

Excluding columns from the result of SELECT *. The IF EXISTS modifier does not throw an error for missing columns.

Examples

SELECT * WITHOUT foo, bar FROM my_table;
SELECT * WITHOUT IF EXISTS foo, bar FROM my_table;

PRAGMA simplecolumns;
SELECT * WITHOUT t.foo FROM my_table AS t
CROSS JOIN (SELECT 1 AS foo) AS v;