Why does the same query work using raw sql but not the select method?

[npearson72]

When I perform the query using the following syntax it works:

const statement = sql`select * from ${items}, json_each(${items.tags}) as "jsonTags"`
  .append(sql` where "jsonTags"."value" ->> '$.name' = 'hello'`)

await searchDB().all(statement);

However the same query using select throws an error:

const columns = getTableColumns(items);

await db
  .select(columns)
  .from(sql`${items}, json_each(${items.tags}) as "jsonTags"`)
  .where(sql` "jsonTags"."value" ->> '$.name' = 'hello'`)

The error:

Your "id" field references a column "items"."id", but the table "items" is not part of the query! Did you forget to join it?

Is this a bug or am I just not using select correctly?

PS: This is using SQLite with a json field.