Request for top level aliasing to be supported as RedShift uses them when unnesting

[kitsunde]

Environment

Knex version: 2.3.0
Database + version: RedShift

Feature discussion / request

1. Explain what is your use case

In RedShift you UNNEST a SUPER type like so:

SELECT value
FROM my_table AS my_table_alias,
my_table_alias.values AS value

But knex drops the alias unless it's a subquery https://knexjs.org/guide/query-builder.html#as so

2. Explain what kind of feature would support this

knex('my_table').as('my_table_alias')

should become

SELECT * FROM my_table AS my_table_alias