We cannnot use aliased column in order by clause

[psvri]

When I tried to use the aliased column in group by , limbo returns a parser error, but it works fine in sqlite3 as shown below.

Sqlite3 output

SQLite version 3.48.0
sqlite> create table temp (t1 integer, t2 integer);
sqlite> insert into temp values (1, 2), (1, 2), (3, 4);
sqlite> select t1 as x from temp order by x;
1
1
3

Limbo output

limbo> create table temp (t1 integer, t2 integer);
limbo> insert into temp values (1, 2), (1, 2), (3, 4);
limbo> select t1 as x from temp order by x;

  × Parse error: Column x not found

[penberg]

Duplicate of #744