5.4.0

What's Changed

• refactor: upgrade version by @taozhi8833998 in #2591
• Update package to support additional types (like VECTOR) by @YaroCabbage in #2593
• feat: support Latin-1 Supplement unicode as column name in tsql by @taozhi8833998 in #2592
• refactor: change table name quoted in snowflake by @taozhi8833998 in #2595
• fix: trim function with multiple args in all dialects by @taozhi8833998 in #2601
• fix: sqlify index_columns multiple order attributes in pg by @taozhi8833998 in #2606
• feat: support drop constraint in pg by @taozhi8833998 in #2607
• fix: optional space between * and select in mysql by @taozhi8833998 in #2609
• fix: struct expr with orderby and limit in bigquery by @taozhi8833998 in #2610
• fix: support bitwise operators by @sgress454 in #2611
• add trino DESCRIBE statement support by @natheihei in #2602
• support mysql straight_join join_op by @alexgann in #2600
• Add GENERATED column support for sqlite by @GrumpyLittleTed in #2560
• feat: support alter table replica identity in pg by @taozhi8833998 in #2618
• fix: cast type with alias in all db by @taozhi8833998 in #2620
• allow set to include the full grammar by @jim-lake in #2616
• handle collate everywhere its legal by @jim-lake in #2625
• feat: support text search type in pg by @taozhi8833998 in #2626
• fix: support returning when insert with no columns in sqlite by @taozhi8833998 in #2627

New Contributors

• @YaroCabbage made their first contribution in #2593
• @natheihei made their first contribution in #2602
• @alexgann made their first contribution in #2600
• @GrumpyLittleTed made their first contribution in #2560

Full Changelog: 5.3.13...5.4.0

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

• @SamBove made their first contribution in #2561

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 INDEX by @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