when using 'WITH', errors me relation 'WITH NAME' does not exist

[PorcoRosso85]

If anyone also encount same question and tells me it, I'm so glad.

db/query.sql:102:1: relation "closure" does not exist

-- name: BatchRelation :exec WITH RECURSIVE closure AS ( SELECT id, path_depth, created_at, ancester_user_id, descendant_user_id FROM relation UNION ALLSELECT hex(randomblob(16)) AS id, closure.path_depth+r.path_depthAS path_depth, CURRENT_TIMESTAMPAS created_at, r.ancester_user_id, closure.descendant_user_idFROM closure JOIN relation r ONclosure.ancester_user_id=r.descendant_user_idWHEREr.path_depth=1 ) INSERT INTO relation_batch ( id, path_depth, created_at, ancester_user_id, descendant_user_id, contract_id ) SELECTclosure.id, closure.path_depth, closure.created_at, closure.ancester_user_id, closure.descendant_user_id, (SELECT contract_id FROM relation WHERE ancester_user_id =closure.ancester_user_idAND descendant_user_id =closure.descendant_user_idLIMIT1) AS contract_id FROM closure WHERE NOT EXISTS ( SELECT1FROM relation_batch WHERErelation_batch.ancester_user_id=closure.ancester_user_idANDrelation_batch.descendant_user_id=closure.descendant_user_idANDrelation_batch.path_depth=closure.path_depth );

[michaelgrijalva-resim]

I just bumped into the same thing. I was able to reproduce the error in a simpler example:

with hello as ( select1as t ) select*from hello wherehello.t=1;

^ This is fine, but nest it into a FROM clause:

select*from ( with hello as ( select1as t ) select*from hello wherehello.t=1 ) j;

queries/summary.sql:88:1: relation "hello" does not exist exit status 1 

It's a silly query but reproduces the issue. Both queries execute fine against my Postgres instance. There may be some shenanigans to make sqlc happy with it, but unclear what 🤔