See also these unofficial interactive release notes: https://antonz.org/sqlite-3-44/ - discussed here: https://news.ycombinator.com/item?id=38095239
My favourite new feature is order by in aggregates, e.g.
select group_concat(name order by name desc)