search

LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
53 stars 24 forks source link

[FRG-180] AS keyword should be optional when defining table and column aliases #692

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[reporter="jhyde", created="Fri, 4 Aug 2006 16:50:17 -0500 (GMT-05:00)"] AS keyword should be optional when defining table and column aliases.

Oracle users are familiar with writing
    select empno columnAlias from emps tableAlias
which means the same as
    select empno AS columnAlias from emps AS tableAlias

Possibly link this to an Oracle-compatability mode.

dynamobi-build commented 12 years ago

[author="jvs", created="Fri, 4 Aug 2006 18:59:13 -0500 (GMT-05:00)"] Huh? This already works; the AS keyword has been optional since forever in the SQL standard.

0: jdbc:farrago:> select name n from sales.depts d;
+------------+
| N |
+------------+
| Sales |
| Marketing |
| Accounts |
+------------+