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.
alt Hacker News
To be fair, most databases don't, since ILIKE is not in the SQL standard.