Parsing nested CTEs

[Gelio]

I found that the following valid PostgreSQL query involving nested CTEs is not parsed correctly by this grammar:

WITH top_cte AS (
  WITH nested_cte AS (
    SELECT 1 as one, 2 as two
  )
  SELECT one, two
  FROM nested_cte
)
SELECT *
FROM top_cte;

Received AST:

(program
  (ERROR
    (statement
      (keyword_with)
      (cte
        (identifier)
        (keyword_as)
        (ERROR
          (keyword_as))
        (statement
          (select
            (keyword_select)
            (select_expression
              (term
                (literal)
                (keyword_as)
                (identifier))
              (term
                (literal)
                (keyword_as)
                (identifier))))))
      (select
        (keyword_select)
        (select_expression
          (term
            (field
              (identifier)))
          (term
            (field
              (identifier)))))
      (from
        (keyword_from)
        (relation
          (object_reference
            (identifier))))))
  (statement
    (select
      (keyword_select)
      (select_expression
        (term
          (all_fields))))
    (from
      (keyword_from)
      (relation
        (object_reference
          (identifier))))))

This SO answer says nested CTEs are not valid, at least for T-SQL. I found that PostgreSQL has no problem executing that query, though:

[matthias-Q]

@dmfay I was thinking that this should be fairly simple. I tested to add $._cte to the choices in

tree-sitter-sql/grammar.js

Line 609 in ddd1763

$._update_statement,

. In my mind this should work, but I still get an error. Any ideas?

[Gelio]

Thank you both @matthias-Q and @dmfay for fixing it so fast!