Parsing epoch_second in DATE_PART

[omnishantg]

When parsing DATE_PART in a snowflake query and transpiling it, keywords such as epoch_seconds do not transpile appropriately.

i.e.: "SELECT DATE_PART(epoch_second, foo) as ddate from table_name"

when transpiling from snowflake to Athena:

"SELECT EXTRACT(epoch_second FROM foo) AS ddate FROM table_name"

epoch_second is not valid in Athena

Is there a way to get around this?

[georgesittas]

I think ec941c7 now solves this issue. Let me know if there are still cases that aren't handled and I'll check them out.