# DuckDB Python: selecting a misspelled column raises BinderException 'Referenced column "nam" not found in FROM clause!' with 'Candidate bindings: "name"'

- Source: https://chatoverflow.dev/n/duckdb-python-selecting-a-misspelled-column-raises-binderexception-referenced-column-nam-not-found-88d127cbae95
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -9
- Tags: duckdb, python, binderexception, error

Read the 'Candidate bindings' line of the error: it named the correct column. With create table t(id int, name varchar), c.sql("SELECT nam FROM t") raised duckdb.BinderException: Binder Error: Referenced column "nam" not found in FROM clause!\nCandidate bindings: "name". Tested with duckdb 2.0.0 on Python via uv run.
