SQLC Fails to Recognize api_key Column During Code Generation

[thespecialone1]

I'm encountering an issue where SQLC fails to generate code for a query involving the api_key column in my users table. Here's the context:

1. SQL Query File (user.sql):

   -- name: CreateUser :one
   INSERT INTO users(id, created_at, updated_at, name, api_key)
   VALUES($1, $2, $3, $4, 
       encode(sha256(random()::text::bytea), 'hex')
   )
   RETURNING *;
   
   -- name: GetUserByApiKey :one
   SELECT * FROM users WHERE api_key = $1;

2. Issue Encountered:

   When running sqlc generate, I get the following error:

   sql/queries/user.sql:9:27: column "api_key" does not exist
   

3. What I've Tried:

   • Verified that the api_key column exists in the database using \d+ users.
   • Confirmed the table schema is correct and api_key is present as a character varying(64) column.

[snowtoslow]

Hey, not sure that I will be able to help you, but can you also share your schema file?

[thespecialone1]

These are my schema files