DuckDB 1.4 LTS

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();

"version"()

v1.4.5

-- a DuckDB query can start with FROM
from range(5) select range as n, range * range as square;

n
square

0
0

1
1

2
4

3
9

4
16

-- lists, structs and lambdas are first-class
select [1,2,3] as list
     , {'name': 'ann', 'tags': ['sql','db']} as record
     , list_transform([1,2,3], x -> x * 2) as doubled;

list
record
doubled

[1, 2, 3]
{'name': ann, 'tags': [sql, db]}
[2, 4, 6]

-- GROUP BY ALL and ORDER BY ALL cut the usual repetition
create table sale (region varchar, amount int);
insert into sale values ('north',10),('north',7),('south',9);
select region, sum(amount) as total from sale group by all order by all;

region
total

north
17

south
9

-- MERGE INTO handles insert-or-update in one statement
create table t (id int primary key, v int);
insert into t values (1,1);
merge into t using (select 1 as id, 9 as v) s on t.id = s.id
  when matched then update set v = s.v;
select * from t;

id
v

1
9