Q011warning

Sortable column not in output

An sgl.sortable list names a column that the query does not select.

db/queries/example.sql:1:1: warning[Q011]: sortable parameter "order_by" references column "created_at" which is not in the query output
Printed by sgl from a small PostgreSQL reproduction project.

When it is reported

The generated ORDER BY can only use columns from the query's own output.

How to fix it

Select the column, or remove it from the sortable list.

See it in an example

In your terminal

$ sgl explain Q011

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