Query works in edgedb ui, but not with client

[haikyuu]

Describe the bug
A clear and concise description of what the bug is.

Reproduction
Run this query:

await client.query(`
Select schema::Module{
  *,
  parent_id := (
	  with p := re_match(r'^(.*?)::[\w]+$', .name)[0]
	  select detached schema::Module filter .name = p LIMIT 1
  )
 }
`)

Expected behavior
It should work. But parent_id is always null.

Versions (please complete the following information):

• OS:
• EdgeDB version (e.g. 2.0): 5.6+adb9e77"
• EdgeDB CLI version (e.g. 2.0): EdgeDB CLI 5.5.1+cc9315a
• edgedb-js version (e.g. 0.20.10;): [email protected]
• Node/Deno version: v20.17.0

Additional context
Add any other context about the problem here.