I'm getting an error trying to use CTEs for

INSERT INTO

jobs. Can someone please tell me what is wrong with my syntax? Please any help will be greatly appreciated. Error:

Error 1064 (HY000): Getting syntax error at line 56, column 4. Detail message: No viable statement for input 'WITH event_with_lag AS (.....

Query:

WITH name AS (...)
  INSERT INTO (...)
  SELECT (...)

in starrocks it is insert into with … select

I thought that syntax was to provide labels?

yes, it is confusing

Can this be clarified in the docs for future devs?

i’m not a dev, you can create an issue or make a pull request for docs

Okay thanks. Also, I assume by "yes, it is confusing" you mean that you put

WITH

after the

INSERT TO

in both labeling and CTE situations?

i tried to search for the docs but ended up testing by hand