SQLite Forum

Aliased function result with the same name issue
Thanks, jake, this is a good source of information. 

I also thought for a while and suspect that the issue I mentioned might be introduced intentionally. 

So we have two variant of alias-enabled queries

  *  The ones that work only in sqlite producing errors on other dbmses. Here sqlite is free to behave like it prefers

  *  The ones that work both in sqlite and other dbmses because the names of alias(es) match(es) the names of columns. So in order for such queries to produce the same results in sqlite as everywhere, Sqlite <b>must</b> pick the column value, not the aliased value.

I also hope that this "feature" will finally get some attention in the documentation.