You dont even need to look into advanced features; sqlite does not support ILIKE.
To be fair, most databases don't, since ILIKE is not in the SQL standard.
To be fair, most databases don't, since ILIKE is not in the SQL standard.