Question mark in comment section recognized as query param

[nsbrokeboy]

Hello, I found issue #1489 and it may be similar, but i think my problem need different fix.
driver: clickhouse-go/v2 v2.30.0

Problem: question mark in comment section recognized as query param.

Example

func main() {
	conn, err := clickhouse.Open(&clickhouse.Options{Addr: []string{"localhost:9001"}})
	if err != nil {
		panic(err)
	}

	row := conn.QueryRow(context.TODO(), "select $1 --some comment with ?", "clickhouse")
	fmt.Println(row.Err())
}

Output:

clickhouse [bind]: mixed named, numeric or positional parameters

I think method bind() has incorrect regexps. Need to edit regexp or pass query in it without comments

[SpencerTorres]

Thanks for submitting this. There are some limitations with the bind regex with how it finds parameters, but this looks like it could be fixed perhaps. There's a lot of edge cases to support