The problem is resolved now I was unaware about the sqlc documentation Query Annotations (Query annotations) which states that each query must have a comment in the format -- name: QueryName :commandType directly above it.

like this one db/queries/account.sql

-- name: CreateAccount :one
insert into accounts(
    owner, balance, currency
) values (
    $1, $2, $3
) returning *;