How to parse a query with reserved keyword (end) in SELECT statement?

[steven-luabase]

I am trying to parse the following query using parse_one:

from sqlglot import parse_one
query = "SELECT END FROM AIRBYTE.STRIPE.INVOICE_LINE_ITEMS_PERIOD;"

parsed_query = parse_one(query, read = "snowflake")

But getting an error of :

ParseError: Invalid expression / Unexpected token. Line 1, Col: 8.
  SELECT END FROM AIRBYTE.STRIPE.INVOICE_LINE_ITEMS_PERIOD

When I put the end column name in quotes "end" like:
SELECT "END" FROM AIRBYTE.STRIPE.INVOICE_LINE_ITEMS_PERIOD;

It parses successfully. Is there a way to have sqlgot parse SELECT queries with reserved keywords in them?

[georgesittas]

Is there a way to have sqlgot parse SELECT queries with reserved keywords in them?

Yes, that is usually solved by adding the token of interest to the ID_VAR_TOKENS set in the parser. I'm not sure what the implications of adding END will be, but I can take a look soon if needed. A PR is welcome, too. :)

[tobymao]

end is a reserved keyword

select end from (select 1 end) x 

this does not work in postgres. i suggest quoting keywords

select "end" from (select 1 end) x