0.22.4 - BigQuery dialect support improvements

v0.22.4

Fixes:

BigQuery:

1. Fixed issue with parsing schemas with project in name.
2. Added support for multiple OPTION() statements

BigQuery OPTIONS in table & column definition

v0.22.1

New Features:

BigQuery:

1. Added support for OPTION for full CREATE TABLE statement & column definition

Improvements:

1. CLUSTED BY can be used without ()

v0.22.0 - fixes & refactoring before adding the support for BigQuery dialect

v0.22.0

New Features:

BigQuery:

I started to add partial support for BigQuery

1. Added support for OPTIONS in CREATE SCHEMA statement

MSSQL:

1. Added support for PRIMARY KEY CLUSTERED - full details about clusterisation are parsed now in separate key 'clustered_primary_key'.
   I don't like that but when I started I did not thought about all those details, so in version 1.0.* I will work on more beutiful and logically output structure.
   #91

Pay attention: previously they parsed somehow, but in incorrect structure.

Improvements:

1. Strings in double quotes moved as separate token from ID to fix a lot of issues with strings with spaces inside
2. Now parser can parse statements separated by new line also (without GO or ; at the end of statement) - #90

Fixes:

1. Now open strings is not valid in checks (previously the was parsed.) Open string sample 'some string (exist open quote, but there is no close quote)
2. Order like ASC, DESK in primary keys now parsed valid (not as previously as column name)

v0.21.0 Big MSSQL support updates

v0.21.0

New Features:

MSSQL:

1. Added support for statements:
   1. PERIOD FOR SYSTEM_TIME in CREATE TABLE statement
   2. ON [PRIMARY] after CREATE TABLE statement (sample in test files test_mssql_specific.py)
   3. WITH statement for TABLE properties
   4. TEXTIMAGE_ON statement
   5. DEFAULT NEXT VALUE FOR in COLUMN DEFAULT

Common:

2. Added support for separating tables DDL by 'GO' statement as in output of MSSQL
3. Added support for CREATE TYPE as TABLE

v0.20.0 SET statement support & some MSSQL & MySQL statements

v0.20.0

New Features:

Common

1. SET statements from DDL scripts now collected as type 'ddl_properties' (if you use group_by_type=True) and parsed as
   dicts with 2 keys inside {'name': 'property name', 'value': 'property value'}

MySQL

2. Added support for MySQL ON UPDATE statements in column (without REFERENCE)

MSSQL

3. Added support for CONSTRAINT [CLUSTERED]... PRIMARY KEY for Table definition
4. Added support for WITH statement in CONSTRAINT (Table definition)

v0.19.7 - Added support for HQL STORED AS INPUTFORMAT, OUTPUTFORMAT, SKEWED BY

v0.19.7

Fixes:

1. Add support for more special symbols to strings - #68

Features:

1. Added support for HQL statements:
   STORED AS INPUTFORMAT, OUTPUTFORMAT - #69
   SKEWED BY

v0.19.6 - HQL TBLPROPERTIES support & bug fixing

v0.19.6

Fixes:

1. Fixed issue with PARTITIONED BY multiple columns in HQL - #66
2. Question symbol '?' now handled valid in strings - #64
3. Fixed issue with escaping symbols & added tests -#63

Features:

1. Added support for HQL statement TBLPROPERTIES - #65

v0.19.5 - COMMENTs finally works in

v0.19.5
Fixes:

1. Fixed issues with COMMENT statement in column definitions. Added bunch of tests, now they expect working ok.

DDL like:

CREATE EXTERNAL TABLE test (
job_id STRING COMMENT 't# est | & * % $ // * 6 % !'
)
STORED AS PARQUET LOCATION 'hdfs://test'

Now parsed valid.

v0.19.0 Base Snowflake support and other

v0.19.0

Features

1. Added support for base Snowflake SQL Dialect.
   Added new --output-mode='snowflake' (add "clone" key)

Added support for CREATE .. CLONE with same behaviour as CREATE .. LIKE
Added support for CREATE .. CLONE for schemas and database - displayed in output as {"clone": {"from": ... }}
CREATE TABLE .. CLUSTER BY ..
CONSTRAINT .. [NOT] ENFORCED (value stored in 'primary_key_enforced')

2. in CREATE DATABASE properties that goes after name like key=value now parsed valid. Check examples in tests
3. Added support for varchar COLLATE column property

v0.18.0: AWS Redshift DDL dialect support

Features

1. Added base support fot AWS Redshift SQL dialect.
   Added support for ENCODE property in column.
   Added new --output-mode='redshift' that add to column 'encrypt' property by default.
   Also add table properties: distkeys, sortkey, diststyle, encode (table level encode), temp.

Supported Redshift statements: SORTKEY, DISTSTYLE, DISTKEY, ENCODE

CREATE TEMP / TEMPORARY TABLE

syntax like with LIKE statement:

create temp table tempevent(like event);