If these is mismatch in aliases as used below, no errors are thrown by sqlc generate:
-- Example queries for sqlc
CREATE TABLE authors (
id BIGSERIAL PRIMARY KEY,
name text NOT NULL,
bio text
);
-- name: GetAuthor :one
SELECT * FROM authors a
WHERE p.id = $1 LIMIT 1;
Playground