SQLite no concept of boolean - stored as 0 or 1
A simple but useful
SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true).
select * from table where deleted='false' which is wrong instead you have to write select * from table where deleted=0