Q022hint

Runtime filters are ANDed

A dynamic: runtime query already has a WHERE, so runtime filters are added with AND.

db/queries/example.sql:1:1: hint[Q022]: a dynamic: runtime query already has a WHERE clause; runtime predicates are appended with AND, not as a new WHERE

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

Printed by sgl from a small PostgreSQL reproduction project.

When it is reported

Reported so you know the merged SQL keeps your static conditions and narrows them, without reading the generated code.

How to fix it

Nothing to fix, if that is what you intended.

See it in an example

014The runtime query builder

In your terminal

$ sgl explain Q022

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