Releases: taozhi8833998/node-sql-parser
Releases · taozhi8833998/node-sql-parser
5.3.13
What's Changed
- Support ROW expressions in trino by @SamBove in #2561
- fix: Support string concatenation in LIKE expressions by @sgress454 in #2552
- feat: support or and expr in aggr function args by @taozhi8833998 in #2567
- feat: add show stmt whitelist check in mysql by @taozhi8833998 in #2568
- fix: custom type support schema prefix in pg by @taozhi8833998 in #2571
- feat: add bit data type in pg by @taozhi8833998 in #2574
- fix: insert into values clause can be union stmt by @taozhi8833998 in #2575
- fix: add create temp table stmt in pg by @taozhi8833998 in #2576
- fix: build error when missing insert_value_clause types in pg by @taozhi8833998 in #2580
- refactor: update type definition by @taozhi8833998 in #2581
- feat: add money data type in pg by @taozhi8833998 in #2590
New Contributors
Full Changelog: 5.3.12...5.3.13
5.3.12
What's Changed
- feat: support func call in array index in pg by @taozhi8833998 in #2524
- refactor: column name starts with an accent by @taozhi8833998 in #2526
- fix: collate could be null in type definition by @taozhi8833998 in #2527
- feat: support generate by default in pg by @taozhi8833998 in #2528
- fix: multiple nested json dot in pg by @taozhi8833998 in #2532
- fix: missing dataset in tableList array in bigquery by @taozhi8833998 in #2540
- fix: column array index in trino by @taozhi8833998 in #2541
- feat: support smallserial data type in pg by @taozhi8833998 in #2543
- fix: multiple array index when sqlify back by @taozhi8833998 in #2544
- feat: support group_concat in sqlite by @taozhi8833998 in #2550
- fix: with clause before select stmt in mysql by @taozhi8833998 in #2553
- perf: remove rest spread Babel plugin by @TrevorBurnham in #2555
- feat: support except in mysql by @taozhi8833998 in #2557
- refactor: upgrade version by @taozhi8833998 in #2559
Full Changelog: 5.3.11...5.3.12
5.3.11
What's Changed
- feat: add boolean type in athena by @taozhi8833998 in #2456
- feat: support comment on extension in pg by @taozhi8833998 in #2457
- fix(types): add expr to DataType by @LestevMisha in #2460
- feat: support load data in mysql by @taozhi8833998 in #2459
- Fix typings for LiteralNull: allow "null" as value (Fix #2468) by @LestevMisha in #2469
- fix: snowflake double quote escape by @danedmunds in #2465
- fix(types) add order_by to ColumnRefItem by @LestevMisha in #2470
- fix: contant string with case sensitive in all db by @taozhi8833998 in #2467
- fix: update set item support full expr in all db by @taozhi8833998 in #2472
- Fix table name by @taozhi8833998 in #2478
- fix: keyword as database and table name in mysql by @taozhi8833998 in #2481
- fix: add literal string column to columnList in all db by @taozhi8833998 in #2484
- feat: support text array type in pg by @taozhi8833998 in #2485
- fix: quoted column name in sqlite by @taozhi8833998 in #2488
- fix: over partition sqlify failed by @taozhi8833998 in #2490
- feat(sqlite): support ESCAPE in LIKE expressions by @sgress454 in #2496
- fix: interval expr with parentheses in all db by @taozhi8833998 in #2497
- fix: multiple joins in mysql and mariadb by @taozhi8833998 in #2503
- feat: support arithmetic with in expr by @taozhi8833998 in #2504
- fix: with cte recursive in all db by @taozhi8833998 in #2507
- feat: support with cte values in all db by @taozhi8833998 in #2508
- fix: xor operator in mysql and mariadb by @taozhi8833998 in #2511
- feat: support network address type in pg by @taozhi8833998 in #2513
- feat: support accentuated identifiers as column in all db by @taozhi8833998 in #2515
- Export AST node types for accurate type guards by @LestevMisha in #2473
- fix: improve types for
CREATE INDEXby @nolanlawson in #2519 - refactor: upgrade version by @taozhi8833998 in #2521
New Contributors
- @LestevMisha made their first contribution in #2460
- @danedmunds made their first contribution in #2465
- @sgress454 made their first contribution in #2496
- @nolanlawson made their first contribution in #2519
Full Changelog: 5.3.10...5.3.11
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