unclosed bracket error, but works on pgadmin

[u007]

migration sample code:

raw(`
CREATE MATERIALIZED VIEW view_papers AS
 SELECT papers.created_at,
    papers.updated_at,
    papers.id,
    papers.name,
    (   setweight(to_tsvector(papers.name::text), 'A'::"char") || 
        setweight(to_tsvector(papers.author_name), 'B'::"char")
    ) || setweight(to_tsvector(papers.description), 'C'::"char")
    AS paper_vector
   FROM
   ( SELECT papers.id, string_agg(categories.code, ',') as categories
    FROM papers
    LEFT JOIN paper_categories ON paper_categories.paper_id=papers.id LEFT JOIN (select * from categories order by weight asc) categories ON categories.id=paper_categories.category_id
    GROUP BY papers.id
   ) a
   LEFT JOIN papers on a.id=papers.id
  WHERE (papers.doc_status = ANY (ARRAY[1, 3])) AND papers.status = 1
WITH DATA
`)

got this error:

...view_papers.up.fizz: line 9: expected next token to be ), got IDENT instead
line 23: no prefix parse function for ) found
line 50: expected next token to be ), got IDENT instead
line 65: no prefix parse function for ) found

[u007]

i think it has something todo with plush script runner

[u007]

i found the work around, replace all " with

 \"

but i think plush should by default be able to handle single " when we use ` in fizz