The issue you raise, (whether an alias can hide the column name in expressions), does not appear to be addressed in the docs. The behavior you see matches what PostgreSQL does. Hence, even if it was not intended originally, (which I doubt), it will be intended once SQLite's management becomes aware of the issue. Expect to see a doc update on this.