There will be no singularity: “duckdb going mad... UNION Type CREATE TABLE messages(u UNION(num INT,…”

duckdb going mad...

UNION Type

CREATE TABLE messages(u UNION(num INT, error VARCHAR));
INSERT INTO messages VALUES (42);
INSERT INTO messages VALUES ('oh my globs');

FROM-first

-- SELECT clause is optional, SELECT * is implied (if not included)
FROM tbl;

-- first 5 rows of the table
FROM tbl LIMIT 5;

-- SELECT can be used after the FROM
FROM tbl SELECT l_orderkey;

-- insert all data from tbl1 into tbl2
INSERT INTO tbl2 FROM tbl1;

BTW SQL standard already has special syntax for it:

TABLE tbl;

COLUMNS Expression

SELECT MIN(COLUMNS(*)), COUNT(*) from obs;
SELECT COLUMNS('val[0-9]+') from obs;

List comprehension support

SELECT [x + 1 for x in [1, 2, 3]] AS l;