v13.0.2 - 2023-05-16
cc7a5de- ensure unit is a var in parse_date_delta (PR #1637 by @GeorgeSittas)
b9140b6- CI/CD: make it so that deployment only requires tag push (PR #1638 by @GeorgeSittas)
v13.0.1 - 2023-05-16
8610298- snowflake: add support for the CLONE clause in DDL statements (PR #1627 by @GeorgeSittas)50025ea- clickhouse: add support for clickhouse's placeholders (PR #1628 by @GeorgeSittas)4b1aa02- optimizer: optimize pivots (PR #1617 by @GeorgeSittas)13a731a- snowflake: translate [CHAR|NCHAR] VARYING into VARCHAR (PR #1634 by @GeorgeSittas)06d6990- snowflake: translate CHARACTER VARYING into VARCHAR too (commit by @GeorgeSittas)c01edb0- create builders for the INSERT statement (PR #1630 by @GeorgeSittas)
99532d9- tablesample losing db closes #1629 (commit by @tobymao)409f13d- missing from comment and spacing closes #1631 (commit by @tobymao)bba360c- clickhouse: map ApproxDistinct to uniq, AnyValue to any (PR #1635 by @GeorgeSittas)↘️ fixes issue #1633 opened by @ewjoachim
v13.0.0 - 2023-05-15
31a82cc- add math associativity simplification (commit by @tobymao)a973113- reparse bigquery nested identifiers (commit by @tobymao)a33112f- bigquery: allow first part of table names to contain dashes (PR #1624 by @GeorgeSittas)
0acfaf7- clickhouse settings and format closes #1605 closes #1604 (commit by @tobymao)b5f0abc- global join clickhouse closes #1606 (commit by @tobymao)d92964b- clickhouse attach command closes #1608 (commit by @tobymao)72f1984- clickhouse cast to string closes #1607 (commit by @tobymao)2f34d6f- clickhouse group by with totals closes #1609 (commit by @tobymao)b75b006- clickhouse paramaterized func closes #1610 (commit by @tobymao)4601831- join/pivot/lateral order and simplify (commit by @tobymao)29e5af2- remove unconditional expression copy (PR #1611 by @tobymao)a67b2de- clickhouse: join type/kind ordering issues (PR #1614 by @pkit)6875d07- clickhouse:USINGallows unwrapped col list (PR #1615 by @pkit)2f7473b- presto sequence to unnest closes #1600 (commit by @tobymao)966dfbb- tokenizer: avoid edge case bug in the trie lookup loop (PR #1619 by @GeorgeSittas)4833953- simplify from to a single expression closes #1620 (PR #1620 by @tobymao)bc0b021- allow identifier params. (commit by @tobymao)
v12.4.0 - 2023-05-12
f585eef- clickhouse: parse ternary operator (PR #1603 by @GeorgeSittas)↘️ addresses issue #1602 opened by @ArtjomKotkov
41b90be- snowflake: Handle form of CONVERT_TIMEZONE with a source TZ (PR #1598 by @pmsanford)4dd413b- expand alias refs was buggy and did the samething expand lateral… (PR #1599 by @tobymao)
v12.2.0 - 2023-05-09
1fa8ae9- sqlite primary key transforms closes #1557 (commit by @tobymao)fb819f0- optimizer: expand join constructs into SELECT * from subqueries (PR #1560 by @GeorgeSittas)↘️ addresses issue #1554 opened by @SudarshanVS
e173dd5- improve tokenizer perf significantly on sql with many strings (commit by @tobymao)c9103fe- Clickhouse: Support large data types (PR #1568 by @matthax)
34b6038- bigquery conversion without table alias (commit by @tobymao)6124d0c- bigquery select distinct as struct (commit by @tobymao)54a7637- postgres exponent precedence closes #1555 (commit by @tobymao)ac60698- array_join -> concat_ws closes #1558 (commit by @tobymao)79a478e- comments refactor closes #1561 (commit by @tobymao)7b09bff- options inside of bigquery struct closes #1562 (commit by @tobymao)4f0b3ed- bigquery date_part WEEK(WEEKDAY) closes #1563 (commit by @tobymao)4744742- presto, spark: remove WITHIN GROUP when transpiling percentile_[cont|disc] (PR #1565 by @GeorgeSittas)23cf246- need to differentiate between peek and curr tokenizers (commit by @tobymao)9f13b6c- base64 closes #1567 (commit by @tobymao)bcfae2c- subquery selects (PR #1569 by @barakalon)34d99ab- spark: unqualify columns in PIVOT expressions (PR #1572 by @GeorgeSittas)e1713f3- preserve quotes in aliases (commit by @tobymao)fa0f3a1- allow any identifier as name when parsing a struct field (PR #1573 by @GeorgeSittas)
951d407- preserve the full text of hex/bin literals (PR #1552 by @GeorgeSittas)5bbb7e8- simplify tokenizer alnum logic (PR #1570 by @GeorgeSittas)
c580cb3- update README optimizer example (commit by @GeorgeSittas)
v12.1.0 - 2023-05-05
0b46fa6- remove bigquery workaround for values type inference (commit by @tobymao)dfae784- sqlite no table options closes #1553 (commit by @tobymao)aef9cfa- double json spark closes #1547 (commit by @tobymao)
v12.0.0 - 2023-05-04
862cbeb- Use alternative transform for dialects that do not support distinct on (PR #1524 by @crericha)52c80e0- Support regex function in Starrocks (PR #1528 by @acreux)00b4779- spark: new Spark2 dialect, improve DATEDIFF sql generation BREAKING (PR #1529 by @GeorgeSittas)e2593ba- Add BYTES type to BigQuery dialect (PR #1536 by @relud)911e4e9- distinct on builder (commit by @tobymao)
5c26f56- windowspec generator (commit by @tobymao)e7111ba- trino: wrap SEQUENCE in an UNNEST call if used as a source (PR #1527 by @GeorgeSittas)3d964c6- use preprocess instead of expanding transform dicts BREAKING (PR #1525 by @GeorgeSittas)5fc27d3- trim with double pipes (commit by @tobymao)9778c16- create table options for bigquery closes #1531 (commit by @tobymao)55dc509- bigquery: allow 2nd argument for PERCENTILE_[CONT|DISC] (PR #1537 by @GeorgeSittas)5c59747- qualifying correlated subqueries (commit by @tobymao)19c0490- parse unnest array type closes #1532 (commit by @tobymao)51ca411- expand laterals first if no schema is present (commit by @tobymao)abfbce2- bigquery udf existing func clash closes #1535 (commit by @tobymao)444dd94- Spark: Add DOUBLE, FLOAT cast functions (PR #1530 by @vegarsti)0578d6d- oracle: allow parsing of @dblink in table names (PR #1540 by @GeorgeSittas)b7e08cc- duckdb: parse DATEDIFF correctly (PR #1546 by @GeorgeSittas)f21abb7- oracle: set post_tablesample_alias=True to fix alias parsing (PR #1548 by @GeorgeSittas)8ebba48- binary_double/float types closes #1543 (commit by @tobymao)2a6a3e7- make some SQL builders pure (PR #1526 by @GeorgeSittas)99310c4- duckdb: remove parentheses from CurrentTimestamp, CurrentDate (PR #1551 by @GeorgeSittas)↘️ fixes issue #1550 opened by @BTheunissen
a113685- spark: cast UnixToTime to TIMESTAMP BREAKING (PR #1549 by @GeorgeSittas)↘️ fixes issue #1545 opened by @joshmarcus
v11.7.0 - 2023-05-02
20cacba- tsql, oracle: add support for NEXT VALUE FOR clause (PR #1521 by @GeorgeSittas)96bb150- builder methods for basic ops (PR #1516 by @tobymao)e11a5ce- add case when change func to parse BREAKING (commit by @tobymao)455b9e9- oracle: support KEEP (.. [FIRST|LAST] ..) window function syntax (PR #1522 by @GeorgeSittas)
94fed8c- call _parse_bitwise as a fallback for nested type args (PR #1515 by @GeorgeSittas)52ab03d- array with method calls (commit by @tobymao)c3db2b8- allow parsing 'if' as an identifier (PR #1517 by @GeorgeSittas)
d5d360a- Remove older CHANGELOG entries and let CI handle it from now on (commit by @GeorgeSittas)
v11.6.3 - 2023-05-01
80287dd- presto: transpile explode/posexplode into (cross join) unnest (PR #1501 by @GeorgeSittas)
efd8c05- redshift doesn't support locks (commit by @tobymao)f4ece7c- comment after paren closes #1504 (commit by @tobymao)85b2c00- postgres doesn't support plural interval closes #1503 (commit by @tobymao)2e0eee6- postgres date_part type closes #1506 (commit by @tobymao)2dcbc7f- tsql hashbytes closes #1508 (commit by @tobymao)5347c7a- change str to Expression in alias_ isinstance check (PR #1510 by @GeorgeSittas)f137815- BigQueryTIMESTAMPandTIMESTAMPTZtypes (PR #1511 by @plaflamme)6143491- allow $ to appear in postgres/redshift identifiers (PR #1512 by @GeorgeSittas)
adc526c- add note about conventional commit naming in CONTRIBUTING.md (commit by @GeorgeSittas)9421650- set action for automatic conventional changelog generation (PR #1513 by @GeorgeSittas)