5.3.5

What's Changed

• refactor: upgrade version by @taozhi8833998 in #2214
• build(deps-dev): bump mocha from 10.7.3 to 10.8.2 by @dependabot in #2202
• build(deps-dev): bump elliptic from 6.5.7 to 6.6.0 by @dependabot in #2198
• refactor: support if not exists stmt in create index stmt in pg by @taozhi8833998 in #2216
• refactor: support listagg function in snowflake by @taozhi8833998 in #2218
• build(deps-dev): bump @babel/register from 7.24.6 to 7.25.9 by @dependabot in #2181
• build(deps-dev): bump eslint-plugin-import from 2.30.0 to 2.31.0 by @dependabot in #2153
• feat: support filter function in athena by @taozhi8833998 in #2222
• fix: key as column in athena by @taozhi8833998 in #2228
• refactor: as can be ignore when UNNEST in athena by @taozhi8833998 in #2229
• feat: support include columns in create index for pg by @taozhi8833998 in #2231
• build(deps-dev): bump @types/mocha from 10.0.9 to 10.0.10 by @dependabot in #2230
• fix: don't require column expression for alter first by @brainsiq in #2233
• refactor: alter table first with optional column in mysql by @taozhi8833998 in #2234
• fix: at time zone with column_ref in pg by @taozhi8833998 in #2235
• Fix vulnerabilities via npm audit fix by @tobiasheldring in #2239
• feat: support float4 and float8 in snowflake by @taozhi8833998 in #2242
• fix: double quoted table mentions in athena and tsql by @taozhi8833998 in #2243
• fix: support real type in athena by @taozhi8833998 in #2244
• feat: support subquery in limit clause by @taozhi8833998 in #2245

New Contributors

• @brainsiq made their first contribution in #2233
• @tobiasheldring made their first contribution in #2239

Full Changelog: 5.3.4...5.3.5

5.3.4

What's Changed

• refactor: upgrade version by @taozhi8833998 in #2172
• feat: support create table option in sqlite by @taozhi8833998 in #2173
• feat: support create index in sqlite by @taozhi8833998 in #2174
• fix: column name can start with digit in mysql by @taozhi8833998 in #2175
• refactor: add type alias for backward-compatible by @taozhi8833998 in #2176
• refactor: add more type definition by @taozhi8833998 in #2178
• build(deps-dev): bump @babel/preset-env from 7.25.4 to 7.25.8 by @dependabot in #2167
• build(deps-dev): bump @babel/core from 7.25.2 to 7.25.8 by @dependabot in #2166
• build(deps-dev): bump @types/mocha from 10.0.8 to 10.0.9 by @dependabot in #2160
• build(deps-dev): bump browserify from 17.0.0 to 17.0.1 by @dependabot in #2154
• build(deps-dev): bump @babel/cli from 7.25.6 to 7.25.9 by @dependabot in #2183
• build(deps-dev): bump @babel/preset-env from 7.25.8 to 7.25.9 by @dependabot in #2182
• feat: export columns method by @taozhi8833998 in #2186
• refactor: change definer expr in mysql by @taozhi8833998 in #2195
• build(deps-dev): bump @babel/preset-env from 7.25.9 to 7.26.0 by @dependabot in #2191
• build(deps-dev): bump @babel/core from 7.25.8 to 7.26.0 by @dependabot in #2190
• feat: support at time zone in pg by @taozhi8833998 in #2205
• fix: with recursive in pg by @taozhi8833998 in #2208
• fix: not null position after generated column in mysql by @taozhi8833998 in #2209
• fix: from clause with multiple parentheses in mysql by @taozhi8833998 in #2210
• feat: support lateral derived tables in mysql by @taozhi8833998 in #2211
• feat: support set time zone in pg by @taozhi8833998 in #2213

Full Changelog: 5.3.3...5.3.4

5.3.3

What's Changed

• fix: limit as keyword in snowflake by @taozhi8833998 in #2095
• feat: support start transaction in pg by @taozhi8833998 in #2097
• fix: text data type can have length setting in mysql by @taozhi8833998 in #2100
• fix: over partition clause after func call in snowflake by @taozhi8833998 in #2102
• fix: convert function to signed in mysql by @taozhi8833998 in #2103
• fix: convert function and as chinese chars in transactsql by @taozhi8833998 in #2106
• fix: create table as table defintion could be optional in pg by @taozhi8833998 in #2108
• refactor: add loc property to func_call in all dialects by @taozhi8833998 in #2109
• fix: reserved keyword as column name in postgresql by @taozhi8833998 in #2112
• feat: support position function in redshift by @taozhi8833998 in #2114
• refactor: add mediumint in pg by @taozhi8833998 in #2116
• build(deps-dev): bump @types/mocha from 10.0.7 to 10.0.8 by @dependabot in #2115
• build(deps-dev): bump eslint-plugin-import from 2.29.1 to 2.30.0 by @dependabot in #2096
• feat: support with clause in create table stmt for flink by @taozhi8833998 in #2122
• fix: limit as keyword in snowflake by @taozhi8833998 in #2125
• fix: convert function with expr in mysql by @taozhi8833998 in #2127
• build(deps-dev): bump babel-loader from 8.3.0 to 8.4.1 by @dependabot in #2121
• feat: support comment on in pg by @taozhi8833998 in #2130
• fix: add _next field to Select interface by @taozhi8833998 in #2135
• fix: distinct on jsonb expr in pg by @taozhi8833998 in #2136
• refactor: support return stmt sql body in create function in pg by @taozhi8833998 in #2138
• build(deps-dev): bump elliptic from 6.5.5 to 6.5.7 by @dependabot in #2092
• build(deps-dev): bump @babel/preset-env from 7.25.3 to 7.25.4 by @dependabot in #2076
• Support 'mod' operator for mysql/mariadb by @TonyGravagno in #2147
• feat: support mod operator in mysql by @taozhi8833998 in #2156
• Make Binary expression type def more flexible by @TrevorBurnham in #2158
• refactor: add schema and server name in tableList by @taozhi8833998 in #2161
• feat: support named params for tumble function in flinksql by @taozhi8833998 in #2164
• feat: support bit data type in mysql by @taozhi8833998 in #2168
• refactor: Insert_Replace values chould be Select type by @taozhi8833998 in #2169
• fix: except op in noql by @taozhi8833998 in #2170
• refactor: add more test cases for sqlite by @taozhi8833998 in #2171

New Contributors

• @TonyGravagno made their first contribution in #2147
• @TrevorBurnham made their first contribution in #2158

Full Changelog: 5.3.2...5.3.3

5.3.2

What's Changed

• refactor: update github action by @taozhi8833998 in #2039
• fix: column options order in mysql by @taozhi8833998 in #2040
• fix: jsonb operator ast order in pg by @taozhi8833998 in #2044
• feat: support create view stmt in bigquery by @taozhi8833998 in #2048
• fix: column constraint in pg by @taozhi8833998 in #2049
• fix: quoted column data type in pg by @taozhi8833998 in #2050
• refactor: change jsonb to binary_expr in all dialects by @taozhi8833998 in #2053
• refactor: support reserved words in as clause in snowflake by @taozhi8833998 in #2055
• refactor: support no space before line comment by @taozhi8833998 in #2056
• refactor: upgrade version by @taozhi8833998 in #2057
• build(deps-dev): bump @babel/cli from 7.24.7 to 7.24.8 by @dependabot in #2004
• fix: mixed cast and jsonb expr by @taozhi8833998 in #2059
• build(deps-dev): bump mocha from 10.6.0 to 10.7.3 by @dependabot in #2061
• fix: add timestamptz data type in pg by @taozhi8833998 in #2063
• build(deps-dev): bump @babel/preset-env from 7.24.7 to 7.25.3 by @dependabot in #2042
• build(deps-dev): bump @babel/core from 7.24.9 to 7.25.2 by @dependabot in #2037
• fix: handle literal string to function name in mysql by @taozhi8833998 in #2066
• fix: key reserved word in sqlite by @taozhi8833998 in #2068
• fix: jsonb bug in pg by @taozhi8833998 in #2071
• fix: in op right could be expr by @taozhi8833998 in #2075
• fix: from table with alias in parentheses by @taozhi8833998 in #2079
• fix: create scheme error in pg by @taozhi8833998 in #2083
• fix: constraint with quoted name by @taozhi8833998 in #2084
• fix: add location when throw args error by @taozhi8833998 in #2069
• refactor: fix location different for same sql in different dialect by @taozhi8833998 in #2085
• fix: limit is not reserved keyword in snowflake by @taozhi8833998 in #2089
• fix: array type could be warpped by angle brackets in athena by @taozhi8833998 in #2090
• build(deps-dev): bump @babel/cli from 7.24.8 to 7.25.6 by @dependabot in #2091
• refactor: upgrade version by @taozhi8833998 in #2093

Full Changelog: 5.3.1...5.3.2

5.3.1

Full Changelog: 5.3.0...5.3.1

5.3.0

What's Changed

• build(deps-dev): bump @babel/register from 7.23.7 to 7.24.6 by @dependabot in #1918
• fix: support if exists in drop table stmt in pg by @taozhi8833998 in #1934
• fix: between star column, support bracket in function args by @taozhi8833998 in #1940
• refactor: update function name and args type by @taozhi8833998 in #1945
• fix: reference table bug in sqlite by @taozhi8833998 in #1954
• refactor: change or_replace to replace field and fix npm run build error by @taozhi8833998 in #1955
• feat: support check constraints in sqlite by @taozhi8833998 in #1959
• feat: support alter table rename column in sqlite by @taozhi8833998 in #1960
• fix: column should not include keywords in sqlite by @taozhi8833998 in #1963
• fix: ilike operator in pg by @taozhi8833998 in #1965
• feat: support with rollup in mysql by @taozhi8833998 in #1966
• Support Column "as" to be ValueExpr by @shgotlib in #1969
• feat: support check constraints in pg by @taozhi8833998 in #1968
• Additional support for Snowflake queries. by @create-new-entity in #1948
• Feat snowflake by @taozhi8833998 in #1971
• refactor: update type definition by @taozhi8833998 in #1973
• build(deps-dev): bump @babel/core from 7.24.6 to 7.24.7 by @dependabot in #1939
• build(deps-dev): bump @babel/preset-env from 7.24.6 to 7.24.7 by @dependabot in #1938
• feat: support top clause and fix multiple union all in snowflake by @taozhi8833998 in #1977
• fix: character set quoted ident by @taozhi8833998 in #1981
• feat: support select into and temporary table in tsql by @taozhi8833998 in #1983
• build(deps-dev): bump @babel/cli from 7.24.6 to 7.24.7 by @dependabot in #1937
• build(deps-dev): bump mocha and @types/mocha by @dependabot in #1982
• refactor: upgrade version by @taozhi8833998 in #1986
• build(deps-dev): bump mocha from 10.5.2 to 10.6.0 by @dependabot in #1989
• Change the type definition of Cast.expr from Expr to ExpressionValue by @LYP951018 in #1987
• fix: collate in mysql by @taozhi8833998 in #1994
• feat: support from unnest in athena by @taozhi8833998 in #1999
• feat: support explain stmt in mysql by @taozhi8833998 in #2001
• feat: support data type array in pg by @taozhi8833998 in #2006
• fix: binary expr as fun args in pg by @taozhi8833998 in #2008
• feat: support generator table rows in snowflake by @taozhi8833998 in #2010
• feat: support unpivot funtion in snowflake by @taozhi8833998 in #2015
• add if exists and only before alter table in pg by @taozhi8833998 in #2011
• Feat jsonb operator pg by @taozhi8833998 in #2017
• build(deps-dev): bump @babel/core from 7.24.7 to 7.24.9 by @dependabot in #2014
• refactor: support create type range and columns in pg by @taozhi8833998 in #2019
• refactor: default expr in all dialects by @taozhi8833998 in #2021
• feat: support * exclude columns in snowflake by @taozhi8833998 in #2026
• fix: type definition by @taozhi8833998 in #2029
• refactor: change sqlite identify from bracket to double quotation / support double equal symbol and subquery by @taozhi8833998 in #2030
• fix: create or replace view in snowflake by @taozhi8833998 in #2034

New Contributors

• @shgotlib made their first contribution in #1969
• @LYP951018 made their first contribution in #1987

Full Changelog: 5.2.0...5.3.0

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