does delete sql query work with CTE or WITH clause in couchbase?
I am facing error : syntax error at: DELETE (reserved word)

WITH inactiveDocs AS (
  SELECT META(d).id
  FROM example_bucket d
  WHERE d.status = "inactive"
)

DELETE FROM example_bucket d
WHERE META(d).id IN (SELECT RAW id FROM inactiveDocs);