knex splits on "as" in column name i.e. knex does not allow "as" in column name

[tzeneva]

Environment

Knex version: latest ( ^0.21.21 )

Bug

knex({ client: 'pg' })
  .select(knex.ref('Date as of'))
  .from('table')
  .toSQL().sql;

or

knex({ client: 'pg' })
  .select(knex.raw('??', 'Date as of'))
  .from('table');
  .toSQL().sql;

return

'select "Date" as "of" from "table"'

whereas I expect

'select "Date as of" from "table"'

Feature discussion / request

There are legitimate cases where a column name contains "as" (the above is from a real in-production example). Splitting on "as" is error-prone and leads to unexpected behavior. Instead, there should be a proper syntax for column aliasing.

This problem is also mentioned in this old issue: #139

[rluvaton]

You can use: (single question mark)

knex({ client: 'pg' })
  .select(knex.raw('?', 'Date as of'))
  .from('table');
  .toSQL().sql;