> <mutters to himself about how much he hates it when AS is intentionally omitted> (not this case, just in general) +1 I get that there is an argument for "less is more" here, but the "AS" makes the human intent clear - and human-readable clarity in code has long-term benefits hard to quantify. It also makes mistakes (like the OP posted) obvious if it breaks with form. PS: @OP, to add - This is not SQLite's peculiarity, it's true of ALL SQL - try it in any Engine for fun.