I'm sure this is news to many and I won't claim that this doesn't belong on HN (if it's upvoted then it's useful), but I feel it's important to point out that this is not a recent development:

> Partial indexes have been supported in SQLite since version 3.8.0 (2013-08-26).