SQLite Forum

Return boolean if item EXISTS in database
Login
You may already know that SQLite does not have a separate boolean type, and that typing, in general, differs from strongly-typed databases.

https://www.sqlite.org/datatype3.html#boolean_datatype