SQLite Forum

Colons in column names?
Login
Not to confuse the matter further, but you'll likely eventually come across queries formulated like:

```
select a a, b b, ...
```

That's semantically identical to:

```
select a as a, b as b, ...
```

Because the "AS" keyword is optional. (Including it arguably improves readability.)

Note that even when using "plain" names, like "a" and "b", the name of the result is technically unspecified unless "AS" is used (or implied, as in the first example above). The sqlite docs used to (years ago) have a sentence to that effect, but i'm unable to find it in the [SELECT docs](https://sqlite.org/lang_select.html).