BOOLEAN in SQLITE is spelled `flag INTEGER NOT NULL CHECK (flag = 0 or flag = 1)`.

Less than ideal, sure. But typing is there when you want to reach for it.

I assume you're being sarcastic because I haven't yet thought of a reason why that'd be a good thing. Although I've never been bitten by SQLite's dynamic types, I wish they weren't a thing.

I'm genuinely curious if there are any real use-cases for this behavior.