Q041error

asyncexec on a synchronous dialect

asyncexec is used on a dialect whose mutations are synchronous.

db/queries/example.sql:1:1: error[Q041]: query "PurgeAuthors" declares asyncexec but dialect "postgres" does not surface asynchronous mutation semantics: asyncexec is only supported on engines that surface asynchronous mutation semantics

   |
 1 | -- sgl.query(PurgeAuthors, asyncexec)
   | ^

Printed by sgl from a small PostgreSQL reproduction project.

When it is reported

asyncexec only means something where acceptance and completion differ, such as ClickHouse. Elsewhere it would quietly behave as exec and hide the intent.

How to fix it

Use exec, execrows or execresult.

See it in an example

036Asynchronous mutations

In your terminal

$ sgl explain Q041

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