Q001warning

Unknown column

A column reference does not resolve in any table or alias in scope.

db/queries/example.sql:2:12: warning[Q001]: unknown column "nmae"

   |
 2 | SELECT id, nmae FROM authors WHERE id = $1;
   |            ^^^^

help: did you mean "name"?

Printed by sgl from a small PostgreSQL reproduction project.

When it is reported

The analyser looks the column up in every table, view, CTE and alias the query can see. When none has it, the column's type is unknown, so it is generated as an untyped value and the query is still written out.

How to fix it

Check the spelling against your migrations, or qualify the column with the right table alias.

In your terminal

$ sgl explain Q001

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