5.3.10

What's Changed

• refactor: support function calls in column defaults for pg by @taozhi8833998 in #2417
• fix: additive expr in column for snowflake by @taozhi8833998 in #2419
• fix: alter table owner to in pg by @taozhi8833998 in #2420
• fix: fetch offset in db2 by @taozhi8833998 in #2421
• feat: support transaction stmt in mysql by @taozhi8833998 in #2423
• feat: support alter sequence in pg by @taozhi8833998 in #2429
• feat(postgres): support delete returning queries by @mnahkies in #2427
• feat(sqlite): support returning on insert, update and delete by @mnahkies in #2428
• fix(snowflake): support try_cast by @cmlee-accelins in #2436
• feat: add returning stmt to type definition by @taozhi8833998 in #2437
• fix: fix case when expr in db by @taozhi8833998 in #2442
• build(deps-dev): bump @babel/core from 7.26.10 to 7.27.4 by @dependabot in #2443
• feat: add ntext data type in tsql by @taozhi8833998 in #2446
• fix: keep last zero when parseFloat in all db by @taozhi8833998 in #2448
• fix: support insert or action in sqlite by @taozhi8833998 in #2450
• refactor: upgrade version by @taozhi8833998 in #2451

New Contributors

• @mnahkies made their first contribution in #2427
• @cmlee-accelins made their first contribution in #2436

Full Changelog: 5.3.9...5.3.10

5.3.9

What's Changed

• refactor: support collate schema in pg by @taozhi8833998 in #2366
• Fix identifier quotes athena by @taozhi8833998 in #2368
• refactor: support join after parentheses in mysql by @taozhi8833998 in #2373
• refactor: database ignore upper or lower case for sqlite by @taozhi8833998 in #2377
• fix: column offset in cast expr in bigquery by @taozhi8833998 in #2381
• feat: support drop type in pg by @taozhi8833998 in #2385
• feat: support contraint key in create table in sqlite by @taozhi8833998 in #2386
• feat: support unlogged table in pg by @taozhi8833998 in #2387
• Fix newline string mariadb by @taozhi8833998 in #2388
• fix: table join using quoted ident in all db by @taozhi8833998 in #2390
• refactor: add scale property to DataType by @taozhi8833998 in #2392
• fix: default row format in mariadb by @taozhi8833998 in #2393
• feat: support alter partition in mysql by @taozhi8833998 in #2395
• fix: add partition in mysql by @taozhi8833998 in #2396
• fix: support row keyword in db2 and tsql by @taozhi8833998 in #2397
• fix: cast type definition by @taozhi8833998 in #2401
• build(deps-dev): bump @babel/cli from 7.26.4 to 7.27.0 by @dependabot in #2363
• refactor: update type definition by @taozhi8833998 in #2403
• refactor: upgrade version by @taozhi8833998 in #2413

Full Changelog: 5.3.8...5.3.9

5.3.8

What's Changed

• feat: support offset,fetch next pattern in tsql by @taozhi8833998 in #2303
• fix: as quoted ident in tsql by @taozhi8833998 in #2304
• fix: assign stmt with alias in mysql by @taozhi8833998 in #2309
• fix: support drop constraint in mysql by @adrianfalleiro in #2323
• fix: varchar and varbinary max in tsql by @taozhi8833998 in #2311
• build(deps-dev): bump mochapack from 2.1.4 to 2.1.5 by @dependabot in #2324
• feat: support table function in bigquery by @taozhi8833998 in #2329
• fix: add collate type in column_ref by @taozhi8833998 in #2333
• fix: whiteList should be exact match by @taozhi8833998 in #2334
• fix: support rows between following and following window func in all db by @taozhi8833998 in #2335
• feat: support make_interval func in pg by @taozhi8833998 in #2336
• build(deps-dev): bump @babel/preset-env from 7.26.0 to 7.26.9 by @dependabot in #2332
• build(deps-dev): bump @babel/core from 7.26.0 to 7.26.9 by @dependabot in #2331
• refactor: support more geometry type in pg by @taozhi8833998 in #2339
• feat: support table-valued function in tsql by @taozhi8833998 in #2341
• refactor: upgrade version by @taozhi8833998 in #2344
• build(deps-dev): bump elliptic from 6.6.0 to 6.6.1 by @dependabot in #2326

New Contributors

• @adrianfalleiro made their first contribution in #2323

Full Changelog: 5.3.7...5.3.8

5.3.7

What's Changed

• refactor: upgrade version by @taozhi8833998 in #2290
• feat: support drop view in pg by @taozhi8833998 in #2292
• refactor: windows function ignore nulls in all db by @taozhi8833998 in #2295
• fix: fetch as keyword in db2 by @taozhi8833998 in #2298
• feat: support string_agg function in tsql by @taozhi8833998 in #2300
• feat: support for json path in tsql by @taozhi8833998 in #2301

Full Changelog: 5.3.6...5.3.7

5.3.6

What's Changed

• refactor: upgrade version by @taozhi8833998 in #2247
• fix: at time zone with func in pg by @taozhi8833998 in #2250
• feat: support range expr as window frame in snowflake by @taozhi8833998 in #2252
• fix: column list include function name by @taozhi8833998 in #2255
• refactor: support function call in partition by clause in pg by @taozhi8833998 in #2259
• build(deps-dev): bump @babel/cli from 7.25.9 to 7.26.4 by @dependabot in #2256
• fix: over window frame current row in snwoflake by @taozhi8833998 in #2266
• fix: over partition clause in athena by @taozhi8833998 in #2271
• fix: quoted function name, from multiple parentheses table in athena by @taozhi8833998 in #2272
• feat: support array_agg function in athena by @taozhi8833998 in #2273
• feat: support trim function in athena by @taozhi8833998 in #2274
• feat: support parentheses value in athena by @taozhi8833998 in #2279
• feat: support u& string in athena by @taozhi8833998 in #2280
• feat: support parse -> operator in athena by @taozhi8833998 in #2281
• fix: array_agg func in athena by @taozhi8833998 in #2282
• fix: collate in mysql by @taozhi8833998 in #2265
• feat: support trim expr in all db by @taozhi8833998 in #2284
• feat: support multiple cast in all db by @taozhi8833998 in #2285
• fix: wrapped column_ref in bigquery by @taozhi8833998 in #2287
• fix: math operation together with array access in bigquery by @taozhi8833998 in #2288

Full Changelog: 5.3.5...5.3.6

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