Magic sql does not add table name in query?

  const userSubQuery = sql<{ logo: string | null; email: string }>`
  (
    SELECT json_build_object(
      'logo', ${users.logo},
      'email', ${users.email}
    )
    FROM ${users}
    WHERE ${users.id} = ${orders.userId}
  )
  `.as("user");
db.select(...getTableColumns(orders), user: userSubQuery).from(orders).where(eq(orders.id, 2))

Query: select "id", ... , "updated_at", "expired_at", 
  (
    SELECT json_build_object(
      'logo', "logo",
      'email', "email"
    )
    FROM "users"
    WHERE "id" = "user_id"
  )
   as "user" from "orders" where "orders"."id" = $1 -- params: [2]