Hacker News new | ask | show | jobs
by debugnik 1409 days ago
> For one thing, in SQLite, it doesn't.

It does now, since the latest release 3.39, along with full join.

1 comments

That's great news!

It'll be a long time before one can use it in portable SQLite queries, for those cases where that matters. I'll continue to eschew the right join for the clarity of only thinking about that relation in one way, but we statically link SQLite for several good reasons, including being able to use new features as they arrive.

Full join is certainly a welcome addition.