SQL has CASE statements, if you’d really like to have all branching logic in pure SQL.