Columns named "desc" cause troulbe in our parser

[sebastian]

Take the following query against the LendingClub data source on demo:

SELECT desc FROM loans

It's rejected with the error:

Expected column definition.

The following version does work:

SELECT "desc" FROM loans

It seems in the first version we parse it as the token descending. The same happens with asc (not that such a column exists...) and all other words which are also part of the general sql syntax...

[cristianberneanu]

I don't think there is anything we should do here. All keywords have this problem.
Postgres behaves similarly:

cloak=> select desc from (select 1 as desc) t;
ERROR:  syntax error at or near "desc"
LINE 1: select desc from (select 1 as desc) t;

[gampleman]

Seems like an improvement would be a better error message.

Expected column definition.

doesn't really tell you what is wrong or how to fix it.

[gampleman]

Would something like this do the trick?

[sebastian]

I think that would be useful!

[sebastian]

Since the fix isn't straightforward (a good fix would require parser changes) I'm moving this out of the current milestone.