Good day! It's my first time writing to a mail list for a very long
time, so I may not get this right the first time.
I would like to request the ability to write:
SELECT *
FROM (VALUES (1, 1), (2, 2)) AS t(a, b)
;
Instead of:
SELECT t.column1 AS a, t.column2 AS b
FROM (VALUES (1, 1), (2, 2)) AS t
;
That is, support column names in AS aliases. Currently I can do that in
PostgreSQL but not in SQLite. The latter gives me this error:
Error: near "(": syntax error
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
