1.9.0

Changes

Added

• Added supports parameterized types.
  • STRING(L)
  • BYTES(L)
  • NUMERIC(P) / NUMERIC(P, S)
  • BIGNUMERIC(P) / BIGNUMERIC(P, S)
• Added supports new data types.
  • INTERVAL
• Added supports Numeric type INT64 aliases.
  • SMALLINT
  • INTEGER
  • BIGINT
  • TINYINT
  • BYTEINT
• Added all data types snippets.
• Added supports table snapshot
  • CREATE SNAPSHOT TABLE DDL statements.
  • INFORMATION_SCHEMA.TABLE_SNAPSHOTS table.
• Added supports Table functions (TVF) DDL statements.
  • CREATE TABLE FUNCTION
  • DROP TABLE FUNCTION
• Added supports new ALTER COLUMN DDL statements.
  • ALTER COLUMN SET OPTIONS
  • ALTER COLUMN SET DATA TYPE
• Added supports new casting functions.
  • PARSE_BIGNUMERIC()
  • PARSE_NUMERIC()
  • Added FORMAT parameter to CAST() function
• Added supports new casting functions.
  • ST_GEOGFROM()
• Added supports DCL statements.
  • GRANT
  • REVOKE
  • INFORMATION_SCHEMA.OBJECT_PRIVILEGES

Changed

• Changed the use single line comment symbol from # to --.
  • BigQuery UI reswitched comment symbol from # to --.

Fixed

• Minor fixed.

Applicable Issues

• fix #39 : Change the use single line comment symbol from '#' to '--' enhancement
• fix #40 : Add supports new data types and snippets enhancement
• fix #41 : Add supports table snapshot enhancement
• fix #42 : Add supports Table functions (TVF) enhancement
• fix #43 : Add supports 'ALTER COLUMN SET (OPTIONS|DATA TYPE)' DDL statements enhancement
• fix #44 : Add supports new casting functions enhancement
• fix #45 : Add supports 'ST_GEOGFROM' Geography functions enhancement
• fix #46 : Add supports DCL statements enhancement