search

nene / prettier-plugin-sql-cst

Prettier SQL plugin that uses sql-parser-cst
https://nene.github.io/prettier-sql-playground/
GNU General Public License v3.0
123 stars 7 forks source link

BigQuery syntax change: CREATE CAPACITY / RESERVATION ASSIGNMENT #3

Closed nene closed 1 year ago

nene commented 1 year ago

Old syntax:

CREATE CAPACITY
project_id.location.commitment_id
AS JSON
capacity_json_object;

CREATE RESERVATION
project_id.location.reservation_id
AS JSON
reservation_json_object;

CREATE ASSIGNMENT
project_id.location.reservation_id.assignment_id
AS JSON
assignment_json_object;

New syntax (since January 12th 2023):

CREATE CAPACITY
`project_id.location_id.commitment_id`
OPTIONS (capacity_commitment_option_list);

CREATE RESERVATION
`project_id.location_id.reservation_id`
OPTIONS (reservation_option_list);

CREATE ASSIGNMENT
`project_id.location_id.reservation_id.assignment_id`
OPTIONS (assignment_option_list);
nene commented 1 year ago

Wrong repo. Moved to: https://github.com/nene/sql-parser-cst/issues/29