SQLite Flow Constructs in SQL?

With MSSQL, I can mix in case, if...t开发者_StackOverflow社区hen, and while constructs in my SQL code. Is anything similar available for SQLite? I have not seen anything on "mixing procedurally" with SQLite, anywhere.

Thanks.

---

SQLite doesn't have any loop syntax - FOR or WHILE. CASE statements are supported rather than IF.