cannot convert symbolIDs["id"] (map index expression of type sq.CustomField) to sq.NumberField about go-structured-query HOT 6 CLOSED

case SymbolSearchWidgit:
	wt := tables.WIDGITS()
	symbolNames := sq.From(wt).
		Select(
			wt.ID,
			sq.Fieldf("lower(unnest(?))", wt.NAMES).As("name"),
		).
		CTE("symbol_names")
	symbolIDs := sq.From(symbolNames).
		Select(
			sq.Count().As("count"),
			symbolNames["id"].As("id"),
			symbolNames["name"].As("name"),
			sq.Fieldf("levenshtein(?, lower(?))", symbolNames["name"], q).As("lev"),
		).
		GroupBy(
			symbolNames["id"],
			symbolNames["name"],
		).
		Where(
			sq.Predicatef("? ILIKE ?", symbolNames["name"], wildcardLikeQuery(q)),
		).
		CTE("symbolIDs")
	query = sq.From(wt).
		// Include both CTEs in the query (order in WITH clause matters!)
		With(
			symbolNames,
			symbolIDs,
		).
		Join(
			symbolIDs,
			symbolIDs["id"].Eq(wt.ID),
		).
		GroupBy(
			wt.ID,
			wt.NAMES,
			symbolIDs["count"],
		).
		OrderBy(
			symbolIDs["count"].Desc(),
			sq.Min(symbolIDs["lev"]),
		).
		Selectx(
			func(r *sq.Row) {
				r.ScanInto(&sr.ID, wt.ID)
				r.ScanArray(&sr.Names, wt.NAMES)
			},
			func() { result = append(result, sr) },
		)

WITH symbolIDs AS (
  	SELECT symbol_names.id, symbol_names.name, levenshtein(symbol_names.name, lower($1)) AS lev
  	FROM symbol_names 
  	WHERE symbol_names.name ILIKE $2
)
SELECT widgits.id, widgits.names
  	FROM public.widgits
  	JOIN symbolIDs 
  	ON :blank: = widgits.id 
  	GROUP BY widgits.id, widgits.names 
  	ORDER BY symbol_names.name DESC, MIN(symbolIDs.lev) 
  	LIMIT $3

wt := tables.WIDGITS()
symbolNames := sq.From(wt).
	Select(wt.ID, sq.Fieldf("lower(unnest(?))", wt.NAMES).As("name")).
  	  	CTE("symbol_names")
  	symbolIDs := sq.From(symbolNames).
  	  	Select(symbolNames["id"], symbolNames["name"], sq.Fieldf("levenshtein(?, lower(?))", symbolNames["name"], q).As("lev")).
  	Where(sq.Predicatef("? ILIKE ?", symbolNames["name"], wildcardLikeQuery(q))).
  	  	CTE("symbolIDs")
  	query = sq.From(wt).
  	  	Join(symbolIDs, symbolIDs["id"].Eq(wt.ID)).
  	  	GroupBy(wt.ID, wt.NAMES).
  	  	OrderBy(symbolNames["name"].Desc(), sq.Min(symbolIDs["lev"])).
  	  	Selectx(
  	  	  	func(r *sq.Row) {
  	  	  	  	r.ScanInto(&sr.ID, wt.ID)
  	  	  	  	r.ScanArray(&sr.Names, wt.NAMES)
  	  	  	},
  	  	  	func() { result = append(result, sr) },
  	  	)

WITH symbolIDs AS (
   SELECT
     id,
     LOWER(UNNEST(names)) AS name
   FROM public.Widgits),
 lev_dist AS (
   SELECT
     id,
     name,
 levenshtein(name, lower('cart')) as lev
 FROM symbolIDs WHERE name like 'cart%')
 SELECT
 widgits.id, widgits.names
 FROM public.widgits
 JOIN lev_dist ON widgits.id=lev_dist.id
 GROUP BY widgits.id, widgits.names
 ORDER BY COUNT(name) DESC, MIN(lev);

wt := tables.WIDGITS()
symbolNames := sq.From(wt).
   Select(wt.ID, sq.Fieldf("lower(unnest(?))", wt.NAMES).As("name")).
   CTE("symbol_names")
symbolIDs := sq.From(symbolNames).
   Select(symbolNames["id"], symbolNames["name"], sq.Fieldf("levenshtein(?, lower(?))", symbolNames["name"], q).As("lev")).
   Where(sq.Predicatef("? ILIKE ?", symbolNames["name"], wildcardLikeQuery(q))).
   CTE("symbolIDs")
query = sq.From(wt).
   With(symbolNames, symbolIDs).
   Join(symbolIDs, symbolIDs["id"].Eq(wt.ID)).
   GroupBy(wt.ID, wt.NAMES).
   OrderBy(symbolIDs["name"].Desc(), sq.Min(symbolIDs["lev"])).
   Selectx(
      func(r *sq.Row) {
         r.ScanInto(&sr.ID, wt.ID)
         r.ScanArray(&sr.Names, wt.NAMES)
      },
       func() { result = append(result, sr) },
   )

WITH symbol_names AS (
    SELECT
    widgits.id,
    lower(unnest(widgits.names)) AS name
    FROM public.widgits),

symbolIDs AS (
    SELECT
    symbol_names.id,
    symbol_names.name,
    levenshtein(symbol_names.name, lower($1)) AS lev
    FROM symbol_names
    WHERE symbol_names.name ILIKE $2
)
    SELECT
    widgits.id, widgits.names
    FROM public.widgits
    JOIN symbolIDs ON :blank: = widgits.id
    GROUP BY widgits.id, widgits.names
    ORDER BY :blank:, MIN(symbolIDs.lev)
    LIMIT $3

symbolIDs := sq.From(symbolNames).
   Select(
      symbolNames["id"].As("id"),
      symbolNames["name"].As("name"),
      sq.Fieldf("levenshtein(?, lower(?))", symbolNames["name"], q).As("lev")
).