SQLite Forum

Two space separated fields in SELECT field list
Login
> <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.