See [expression syntax](https://sqlite.org/lang_expr.html) and [explanation of IS and IS NOT](https://sqlite.org/lang_expr.html#isisnot). To answer your question: IS is used when applications or users determine that functionality is needed and act accordingly.