[Question] does not supported Positional Parameters?

[goccy]

[Question] does not supported Positional Parameters?

[goccy]

This issue has been fixed in v0.1.7. If you have any problems, please reopen this.

[goccy]

There is a type called ParameterMode in go-zetasql ( https://github.com/goccy/go-zetasql/blob/c0cdb2761078bdee9a269bcb29da4686d7ad4869/enum.go#L6-L19 ) that bigquery emulator uses.
As far as I know, this value can only be applied one at a time, so it may be difficult to enable positional parameter or named parameter at the same time 🤔

[goccy]

I found a way to solve this problem ! I'll fix this problem as soon as possible !

[halnique]

I have confirmed that Named Parameters is working.

$ bq --api http://0.0.0.0:9050 query --use_legacy_sql=false --parameter=id:integer:1 --project_id=test "select * from dataset1.table_a where id = @id"
[
  {
    "id": "1", 
    "name": "alice"
  }
]

bigquery-emulator logged the following.

2022-08-26T03:43:43.254Z	INFO	server/middleware.go:41	GET /discovery/v1/apis/bigquery/v2/rest	{"query": ""}
2022-08-26T03:43:43.282Z	INFO	server/middleware.go:41	POST /projects/test/jobs	{"query": "alt=json"}
2022-08-26T03:43:43.286Z	INFO	contentdata/repository.go:145		{"query": "select * from dataset1.table_a where id = @id", "values": ["1"]}
2022-08-26T03:43:43.286Z	DEBUG	contentdata/repository.go:208	query result	{"rows": [[1,"alice"]]}
2022-08-26T03:43:43.294Z	INFO	server/middleware.go:41	GET /projects/test/queries/bqjob_r3513523cffe35404_00000182d83f9a8e_1	{"query": "timeoutMs=0&startIndex=0&alt=json&maxResults=100"}

[halnique]

Amazing! I will look forward to it.