package main

func main() {
	// spannerClient created per best practices
	rowIter := spannerClient.Single().Query(
		context.Background(),
		spanner.Statement{SQL: `
		SELECT
			Id,
			OtherId,
		FROM Items
		ORDER BY OtherId DESC
		`},
	)
	defer rowIter.Stop()

	var dest []struct {
		Id        string
		OtherId Inner[string]
	}

	if err := spanner.SelectAll(rowIter, &dest); err != nil {
		t.Fatal(err)
	}
	for _, d := range dest {
		fmt.Println(d)
	}
}


type Inner[T any] struct {
	val T
}

func (n *Inner[T]) DecodeSpanner(input any) error {
	switch val := input.(type) {
	case T:
		n.val = val
		return nil
	case *T:
		if val == nil {
			return nil
		}
		n.val = *val
		return nil
	}
	panic("n/a")
}