[FEATURE]: Teradata DDL conversion enhancement

[sriram251-code]

Is there an existing issue for this?

• I have searched the existing issues

Category of feature request

Transpile

Problem statement

The AST is incorrectly interpreting WEEK_OF_YEAR_US as a function instead of recognizing it as a column. This issue needs to be resolved to ensure correct parsing

ex:

REPLACE VIEW A.VIEWB
AS
LOCKING TABLE SCHEMAA.TABLEC FOR ACCESS

SELECT

      CAST((WEEK_OF_YEAR_US (FORMAT '99')) AS CHAR(2))                  AS COL1

FROM
    SCHEMAA.TABLEC;

Proposed Solution

Parsing strategy needs to be changed

Additional Context

No response