Q014warning
group_by column not in output
The group_by column is not in the query's output.
db/queries/example.sql:1:1: warning[Q014]: sgl.group_by references column "authors.bio" which is not in the query output
Printed by sgl from a small PostgreSQL reproduction project.
When it is reported
group_by collapses repeated parent rows of an embed join using the named column, so the query has to select it.
How to fix it
Select the column, or name one the query already selects.
See it in an example
In your terminal
$ sgl explain Q014
Look for GroupByColumnMissing in Seagull's source to see where it is reported.