SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select sqlite_version();

sqlite_version()

3.39.4

-- RIGHT and FULL OUTER JOIN arrived in SQLite 3.39
create table l (id int, name text);
insert into l values (1,'ann'),(2,'bob');
create table r (id int, city text);
insert into r values (2,'york'),(3,'bath');

2 rows affected

2 rows affected

select l.name, r.city
from l full outer join r on r.id = l.id
order by coalesce(l.id, r.id);

name
city

ann
null

bob
york

null
bath

-- RETURNING and STRICT tables are also new since 3.27
create table t (x int) strict;
insert into t values (7) returning x;

x

7

1 row affected