5.2.0

What's Changed

• refactor: update github action by @taozhi8833998 in #1890
• build(deps-dev): bump @babel/preset-env from 7.24.4 to 7.24.5 by @dependabot in #1886
• build(deps-dev): bump @babel/core from 7.24.4 to 7.24.5 by @dependabot in #1885
• build(deps-dev): bump @babel/cli from 7.24.1 to 7.24.5 by @dependabot in #1884
• fix: unary operator in redshift by @taozhi8833998 in #1893
• fix: string_agg function in pg by @taozhi8833998 in #1895
• fix: types definition by @taozhi8833998 in #1896
• fix: sum expr in mysql by @taozhi8833998 in #1899
• refactor: add escape test case for mysql by @taozhi8833998 in #1901
• fix: over partition and extract in athena by @taozhi8833998 in #1903
• fix: add getLocationObject function in redshift by @taozhi8833998 in #1904
• build(deps-dev): bump rimraf from 5.0.5 to 5.0.7 by @dependabot in #1905
• build(deps-dev): bump chai from 4.4.1 to 5.1.1 by @dependabot in #1898
• Revert "build(deps-dev): bump chai from 4.4.1 to 5.1.1" by @taozhi8833998 in #1908
• feat: support multiple set items in mysql by @taozhi8833998 in #1911
• Added support for additional snowflake data types by @create-new-entity in #1913
• build(deps-dev): bump @babel/preset-env from 7.24.5 to 7.24.6 by @dependabot in #1917
• fix: create database with quoted db name in all dialect by @taozhi8833998 in #1924
• build(deps-dev): bump @babel/cli from 7.24.5 to 7.24.6 by @dependabot in #1920
• build(deps-dev): bump @babel/core from 7.24.5 to 7.24.6 by @dependabot in #1919
• feat: support create table in mysql 8.x and drop view in sqlite by @taozhi8833998 in #1930
• refactor: upgrade version by @taozhi8833998 in #1932

New Contributors

• @create-new-entity made their first contribution in #1913

Full Changelog: 5.1.0...5.2.0

5.1.0

What's Changed

• Refactor type by @taozhi8833998 in #1843
• fix: github action by @taozhi8833998 in #1844
• build(deps-dev): bump mocha from 10.3.0 to 10.4.0 by @dependabot in #1845
• build(deps-dev): bump @babel/preset-env from 7.24.1 to 7.24.3 by @dependabot in #1840
• build(deps-dev): bump @babel/cli from 7.23.9 to 7.24.1 by @dependabot in #1836
• fix: distinct and top position in tsql by @taozhi8833998 in #1847
• fix: slow deep nest function sql in all db by @taozhi8833998 in #1849
• chore: improve create_definitions types by @DemonHa in #1855
• feat: support traversing semi-structured data with colons(:) in snowflake by @taozhi8833998 in #1856
• fix: support collate after multiple conditions in brackets in mysql by @taozhi8833998 in #1858
• feat: support json visitor in snowflake by @taozhi8833998 in #1861
• fix: count args in mysql by @taozhi8833998 in #1867
• Fix alter table after mysql by @taozhi8833998 in #1869
• fix: json as table function in pg by @taozhi8833998 in #1870
• feat: support temporal table in tsql by @taozhi8833998 in #1871
• feat: support declaritive partitions in pg by @taozhi8833998 in #1873
• build(deps-dev): bump @babel/preset-env from 7.24.3 to 7.24.4 by @dependabot in #1851
• fix: auto generated types by @DemonHa in #1868
• feat: support more set stmt in tsql by @taozhi8833998 in #1878
• feat: support map expr in flink by @taozhi8833998 in #1880
• fix: check constraint in mysql by @taozhi8833998 in #1881
• fix: broken type generator by @DemonHa in #1883
• feat: support json object in flinksql by @taozhi8833998 in #1882
• refactor: upgrade version by @taozhi8833998 in #1887
• refactor: update github action to v4 by @taozhi8833998 in #1888
• Create manual.yml by @taozhi8833998 in #1889

New Contributors

• @DemonHa made their first contribution in #1855

Full Changelog: 5.0.0...5.1.0

5.0.0

What's Changed

• build(deps-dev): bump @babel/preset-env from 7.23.7 to 7.23.8 by @dependabot in #1751
• refactor: upgrade version by @taozhi8833998 in #1756
• feat: support number data type in snowflake by @taozhi8833998 in #1758
• feat: support set to value in pg by @taozhi8833998 in #1761
• fix: check constraint support and expr in mysql by @taozhi8833998 in #1763
• fix: double quoted column cast in pg by @taozhi8833998 in #1765
• feat: support transaction keyword in pg by @taozhi8833998 in #1772
• refactor: for publish by @taozhi8833998 in #1773
• refactor: registry.npm.taobao.org cert expired by @taozhi8833998 in #1774
• refactor: registry.npm.taobao.org cert expired by @taozhi8833998 in #1775
• refactor: downgrade chai by @taozhi8833998 in #1776
• build(deps-dev): bump @babel/cli from 7.23.4 to 7.23.9 by @dependabot in #1771
• fix: github action by @taozhi8833998 in #1777
• fix: package json author by @taozhi8833998 in #1778
• refactor: move env by @taozhi8833998 in #1779
• build(deps-dev): bump @babel/preset-env from 7.23.8 to 7.23.9 by @dependabot in #1769
• build(deps-dev): bump @babel/core from 7.23.7 to 7.23.9 by @dependabot in #1770
• fix: intersect multiple sql in nosql by @taozhi8833998 in #1783
• feat: add interval week unit in bigquery by @taozhi8833998 in #1786
• Refactor quoted type by @taozhi8833998 in #1787
• fix: show index from table in mysql by @taozhi8833998 in #1793
• refactor: support quoted function name, quoted schema name in pg by @taozhi8833998 in #1794
• feat: support cross and outer apply in tsql by @taozhi8833998 in #1795
• fix: column ref in pg by @taozhi8833998 in #1802
• fix: full qualified column in tsql by @taozhi8833998 in #1803
• feat: support custom data type by create type in pg by @taozhi8833998 in #1804
• feat: add redshift by @taozhi8833998 in #1806
• fix: table name starts with number or lodash ignore keywords in mysql by @taozhi8833998 in #1809
• build(deps-dev): bump eslint from 8.56.0 to 8.57.0 by @dependabot in #1810
• build(deps-dev): bump mocha from 10.2.0 to 10.3.0 by @dependabot in #1792
• fix: truncate table with option in pg by @taozhi8833998 in #1813
• feat: support updating JSON using subscripting in pg by @taozhi8833998 in #1818
• build(deps-dev): bump @babel/preset-env from 7.23.9 to 7.24.0 by @dependabot in #1816
• build(deps-dev): bump @babel/core from 7.23.9 to 7.24.0 by @dependabot in #1815
• fix(snowflake): support the REGEXP / NOT REGEXP operator by @cchepelov in #1822
• feat: support athena by @taozhi8833998 in #1824
• refactor: change all function with all quoted object by @taozhi8833998 in #1827
• refactor: new function name types by @darzIdo in #1828
• refactor: new function name types by @darzIdo in #1831
• refactor: update version by @taozhi8833998 in #1830
• build(deps-dev): bump @babel/preset-env from 7.24.0 to 7.24.1 by @dependabot in #1838
• build(deps-dev): bump @babel/core from 7.24.0 to 7.24.3 by @dependabot in #1841
• feat: add location option support and trino dialect by @qwinzIdo in #1680
• fix: bigquery array brackets and parentheses handling by @darzIdo in #1833

New Contributors

• @cchepelov made their first contribution in #1822
• @darzIdo made their first contribution in #1828
• @qwinzIdo made their first contribution in #1680

Full Changelog: 4.18.0...5.0.0

4.18.0

What's Changed

• refactor: upgrade version by @taozhi8833998 in #1723
• fix: json array access in where clause in bigquery by @taozhi8833998 in #1726
• fix: alter table modify column keyword is optional in mysql by @taozhi8833998 in #1729
• fix: count function args with or expr in all db by @taozhi8833998 in #1730
• build(deps-dev): bump @babel/preset-env from 7.23.5 to 7.23.6 by @dependabot in #1699
• feat: support accentuated characters in column of pg by @taozhi8833998 in #1732
• fix: case when then expr with additive in pg by @taozhi8833998 in #1735
• build(deps-dev): bump eslint from 8.55.0 to 8.56.0 by @dependabot in #1728
• refactor: update type definition by @taozhi8833998 in #1736
• build(deps-dev): bump eslint-plugin-import from 2.29.0 to 2.29.1 by @dependabot in #1716
• feat: support create user in mysql by @taozhi8833998 in #1737
• refactor: update type definition by @taozhi8833998 in #1739
• build(deps-dev): bump chai from 4.3.10 to 5.0.0 by @dependabot in #1738
• build(deps-dev): bump @babel/core from 7.23.6 to 7.23.7 by @dependabot in #1740
• build(deps-dev): bump @babel/preset-env from 7.23.6 to 7.23.7 by @dependabot in #1741
• build(deps-dev): bump @babel/register from 7.22.15 to 7.23.7 by @dependabot in #1742
• fix: as double quoted in pg by @taozhi8833998 in #1745
• feat: support intersect and except op in pg by @taozhi8833998 in #1748
• feat: add noql dialect by @taozhi8833998 in #1750
• fix: data index in mariadb by @taozhi8833998 in #1752
• Feat double slash comment snowflake by @taozhi8833998 in #1755

Full Changelog: 4.17.0...4.18.0

4.17.0

Full Changelog: 4.16.0...4.17.0

4.16.0

What's Changed

• refactor: upgrade version by @taozhi8833998 in #1713
• fix: alter table drop index with identified in mysql by @taozhi8833998 in #1717
• build(deps-dev): bump @babel/core from 7.23.5 to 7.23.6 by @dependabot in #1698
• Fix some AST typescript types by @tbantle22 in #1720
• feat: support json type, fix array column vistior in bigquery by @taozhi8833998 in #1722

New Contributors

• @tbantle22 made their first contribution in #1720

Full Changelog: 4.15.0...4.16.0

4.15.0

What's Changed

• feat: support string_agg function in bigquery by @taozhi8833998 in #1702
• fix: array sqlify not right in bigquery by @taozhi8833998 in #1703
• refactor: upgrade version by @taozhi8833998 in #1704
• fix: column offset in bigquery by @taozhi8833998 in #1707
• Use typeof comparaison on global object for browsers usage by @PaulRosset in #1708
• fix: table prefix star with except in bigquery by @taozhi8833998 in #1711
• fix: crosstab in pg by @taozhi8833998 in #1712

New Contributors

• @PaulRosset made their first contribution in #1708

Full Changelog: 4.14.0...4.15.0

4.14.0

Full Changelog: 4.13.0...4.14.0

4.13.0

What's Changed

• refactor: add function type by @taozhi8833998 in #1690
• feat: support crosstab tablefunc in pg by @taozhi8833998 in #1693
• feat: support create view stmt in sqlite by @taozhi8833998 in #1695
• engine attributes and data directories by @jim-lake in #1683

Full Changelog: 4.12.0...4.13.0

fix aggregate func args, convert function in MySQL, support drop index and key, like params

What's Changed

• feat: support execute stmt in pg by @taozhi8833998 in #1552
• feat: support for loop stmt in pg by @taozhi8833998 in #1554
• refactor: update pg definition by @taozhi8833998 in #1555
• fix: on update now() in mysql by @taozhi8833998 in #1557
• fix: keep origin quote string type by @taozhi8833998 in #1560
• feat: support accentuated characters in pg by @taozhi8833998 in #1570
• fix: support order by for column in create constaint in mysql by @taozhi8833998 in #1572
• fix: support keyword as column name in create table sql in sqlite by @taozhi8833998 in #1576
• fix: sqlify to mariadb for autoincrement from sqlite by @taozhi8833998 in #1578
• fix: primary key missing when have unique in sqlify by @taozhi8833998 in #1581
• fix: character varying as data type in pg by @taozhi8833998 in #1584
• fix: sqlify from mariadb ast to sqlite by @taozhi8833998 in #1585
• refactor: update pg definition by @taozhi8833998 in #1589
• refactor: upgrade version by @taozhi8833998 in #1590
• fix: datatype length missing parentheses in all db by @taozhi8833998 in #1602
• fix: join multiple tables in mysql by @taozhi8833998 in #1603
• refactor: support real in sqlite by @taozhi8833998 in #1610
• fix: convert fun in mysql by @taozhi8833998 in #1612
• feat: support checksum and delay_key_write table option in create table by @taozhi8833998 in #1613
• select requires := for assignment, otherwise its a binary operator by @jim-lake in #1616
• allow db prefix in column_refs by @jim-lake in #1605
• refactor: ast be object when single sql, to be array when multiple statements for all db by @taozhi8833998 in #1615
• Feat db prefix column mysql by @taozhi8833998 in #1618
• fix: add more extract field in mysql by @taozhi8833998 in #1621
• fix: extract filed bug in bigquery by @taozhi8833998 in #1626
• feat: support exec stmt without parameters by @WillyWangCn in #1630
• Fix sqlify column snowflake by @taozhi8833998 in #1633
• fix: create table failed in bigquery by @taozhi8833998 in #1637
• fix: column type definition by @taozhi8833998 in #1639
• support all interval types by @jim-lake in #1643
• fix: table name starts with number or lodash in mysql by @taozhi8833998 in #1646
• feat: support show create event, trigger and procedure in mysql by @taozhi8833998 in #1647
• support ignore in insert set by @jim-lake in #1649
• feat: support insert ignore into in mysql by @taozhi8833998 in #1651
• fix: inner join in mssql by @taozhi8833998 in #1654
• feat: support create table in bigquery by @taozhi8833998 in #1655
• fix: set column name can be reserved word by @taozhi8833998 in #1660
• fix unary operation by @jim-lake in #1664
• feat: add unary operator in binary expr in mysql by @taozhi8833998 in #1663
• feat: support like param in mysql by @taozhi8833998 in #1667
• refactor: format unary by @taozhi8833998 in #1668
• refactor: update type for where field by @taozhi8833998 in #1675
• drop index support in alter command by @jim-lake in #1679
• feat: support drop index and key in mysql by @taozhi8833998 in #1681
• fix: aggreate should throw error when args is not right in mysql by @taozhi8833998 in #1684
• feat: add double precision type in pg by @taozhi8833998 in #1687

New Contributors

• @jim-lake made their first contribution in #1616
• @WillyWangCn made their first contribution in #1630

Full Changelog: 4.11.0...4.12.0