Sounds like a basic question but I couldn't seem to find it. Is there a way to define in SQLite a column which will be a single bit?
SQLite
bit
SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true).
Source
AS at 2021-01-20, I should say YES, you can define bit datatype in SQLite and it's working.
No.
Source