Q024warning

No Count for this query

A dynamic: runtime query could not be rewritten as a COUNT, so its builder has no Count(ctx).

db/queries/example.sql:1:1: warning[Q024]: a dynamic: runtime query could not be rewritten into a COUNT query; .Count(ctx) is unavailable for this query

   |
 1 | -- sgl.query(PurgeAuthors, many, dynamic: runtime)
   | ^

Printed by sgl from a small PostgreSQL reproduction project.

When it is reported

The rewriter needs a top-level SELECT. The query still generates; only the count terminal is missing.

How to fix it

Simplify the top level of the query if you need Count.

See it in an example

014The runtime query builder

In your terminal

$ sgl explain Q024

Look for CountRewriteUnavailable in Seagull's source to see where it is reported.