Parser doesn't support column list with subquery alias

[ritwizsinha]

Overview of the Issue

The parser tests fail when we give column list to the subquery alias. When we have a query such as

select `name`, numbers from (select * from users) as x(`name`, numbers);

with the users table schema as

+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id      | varchar(255) | YES  |     | NULL    |       |
| rollnos | int          | YES  |     | NULL    |       |
+---------+--------------+------+-----+---------+-------+

while the same query is valid in MySQL