You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
BigQuery can use named (@age, @name, …) or ordered (repeating ?) parameters
but it's not true,
tried both dbq.query('SELECT ... @name', [ name ]) which ends up Error: Named parameters are not supported at [33:25];
or dbq.query('SELECT ... @name', { name }) got Error: Bad request,
have to change to the ordered form dbq.query(' SELECT ... ? ', [ name ]) which is the only way can work for now;
Describe the solution you'd like
should support BigQuery named parameters, either dbq.query(' SELECT ... @name ', { name }) or whatever, how can you pass in the named parameters?
many other DB servers also have similar named parameters features, it saves when large chunk of SQL have reference same parameter many times,
the doc page have mentioned Oracle can use named parameters, not sure if all are FALSE for named parameters support?
Oracle can use named (:age, :name, …) or ordered (repeating ?) parameters
SQL Server can use named (@age, @name, …) parameters
The text was updated successfully, but these errors were encountered:
tx0c
changed the title
bug and should support BigQuery named parameters
bug in BigQuery named parameters
Mar 8, 2024
tx0c
changed the title
bug in BigQuery named parameters
bug in BigQuery named parameters, doc example request if it works, or request to fix the bug
Mar 11, 2024
Is your feature request related to a problem? Please describe.
https://observablehq.com/documentation/misc/standard-library#clientQuery says
but it's not true,
tried both
dbq.query('SELECT ... @name', [ name ])
which ends upError: Named parameters are not supported at [33:25]
;or
dbq.query('SELECT ... @name', { name })
gotError: Bad request
,have to change to the ordered form
dbq.query(' SELECT ... ? ', [ name ])
which is the only way can work for now;Describe the solution you'd like
should support BigQuery named parameters, either
dbq.query(' SELECT ... @name ', { name })
or whatever, how can you pass in the named parameters?many other DB servers also have similar named parameters features, it saves when large chunk of SQL have reference same parameter many times,
the doc page have mentioned Oracle can use named parameters, not sure if all are FALSE for named parameters support?
The text was updated successfully, but these errors were encountered: