On 17 Mar 2019, at 5:19pm, niklas <[email protected]> wrote: > Is this a recent change in Sqlite or have I misunderstood something? The > Sqlite documentation still does not seem to say that column aliases can be > used in the WHERE clause at least.
You are correct in two things. Column aliases cannot be relied on inside the WHERE clause or any other clause. You should imagine that they are used only when the SELECT statement is ready to return values. And also that some implementations of SQL allow the 'AS' names to be used for other purposes, but this is not in the SQL specification. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
