[Question] does not supported Positional Parameters?

[halnique]

Thanks for the goccy/bigquery-emulator, it is a very useful feature.

Can I use BigQuery Positional Parameters?
https://cloud.google.com/bigquery/docs/samples/bigquery-query-params-positional

In my environment, an error has occurred. (Using docker image)

$ bq --api http://0.0.0.0:9050 query --use_legacy_sql=false --parameter=:integer:1 --project_id=test "select * from dataset1.table_a where id = ?"
You have encountered a bug in the BigQuery CLI. Please file a bug report in our public issue tracker:
https://issuetracker.google.com/issues/new?component=187149&template=0
Please include a brief description of the steps that led to this issue, as well as any rows that can be made public from the following information:

========================================
== Platform ==
  CPython:2.7.16:Darwin-19.6.0-x86_64-i386-64bit
== bq version ==
  2.0.75

...

========================================

Unexpected exception in query operation: You have encountered a bug in the BigQuery CLI. Please file a bug report in our public issue tracker:
https://issuetracker.google.com/issues/new?component=187149&template=0
Please include a brief description of the steps that led to this issue, as well as any rows that can be made public from the following information:

bigquery-emulator logged the following.

2022-08-26T03:24:31.949Z	INFO	server/middleware.go:41	GET /discovery/v1/apis/bigquery/v2/rest	{"query": ""}
2022-08-26T03:24:31.977Z	INFO	server/middleware.go:41	POST /projects/test/jobs	{"query": "alt=json"}
2022-08-26T03:24:31.982Z	INFO	contentdata/repository.go:145		{"query": "select * from dataset1.table_a where id = ?", "values": ["1"]}
2022-08-26T03:24:31.990Z	INFO	server/middleware.go:41	GET /projects/test/queries/bqjob_r4eb0707bb65b00af_00000182d82e0938_1	{"query": "timeoutMs=0&startIndex=0&alt=json&maxResults=100"}
2022-08-26T03:24:32.097Z	ERROR	server/handler.go:41	internal error	{"error": "INVALID_ARGUMENT: Positional parameters are not supported [at 1:43]"}

In actual Google BigQuery, it works as follows.

$ bq query --use_legacy_sql=false --parameter=:integer:1 --project_id=my-project 'select * from dataset1.table_a where id = ?'
[
  {
    "id": "1", 
    "name": "alice"
  }
]

Is there any option to make Positional Parameters available?

[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"}

[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]

Amazing! I will look forward to it.

[goccy]

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