Does sqlite support any kind of IF(condition) statement in a select
See the case expression.
A CASE expression serves a role similar to IF-THEN-ELSE in other programming languages.
For your example
select case when length(a) > 4 then a else '' end as b
from foo
You can use case for that:
select case when length(a)>4 then a else ' ' end from foo;