• feat: support distinctrow keyword by @EmilyOng in https://github.com/JSQLParser/JSqlParser/pull/2238
• Exasol: IMPORT/EXPORT by @ssteinhauser in https://github.com/JSQLParser/JSqlParser/pull/2256
• Add pluginRepositories to pom.xml by @davyboyhayes in https://github.com/JSQLParser/JSqlParser/pull/2284
• Fix[2283] - Fix broken ParserKeywordsUtilsTest by @davyboyhayes in https://github.com/JSQLParser/JSqlParser/pull/2286
• Fix[2288] - Support parenthesed expressions within Between by @davyboyhayes in https://github.com/JSQLParser/JSqlParser/pull/2289
• Fix[2290] - Fix overeager lambda function parsing by @davyboyhayes in https://github.com/JSQLParser/JSqlParser/pull/2293
• support opengauss "on duplicate key update nothing" grammar by @zhangconan in https://github.com/JSQLParser/JSqlParser/pull/2303
• feat(parser): allow COLLATE in ORDER BY clauses (issue #2245) by @ldaIas in https://github.com/JSQLParser/JSqlParser/pull/2277
• Fix[2306] - Adds support for Trino UDF by @davyboyhayes in https://github.com/JSQLParser/JSqlParser/pull/2307
• Fix[2312] - Fixes issue with array in function declaration by @davyboyhayes in https://github.com/JSQLParser/JSqlParser/pull/2313
• Added new features to support the complete delete using syntax of pg database, such as subqueries, etc. by @zhangconan in https://github.com/JSQLParser/JSqlParser/pull/2316
• [feat] Support for LOCK-Statements by @ANeumann82 in https://github.com/JSQLParser/JSqlParser/pull/2321
• [feat] Support for FOR READ ONLY/FOR FETCH ONLY by @ANeumann82 in https://github.com/JSQLParser/JSqlParser/pull/2325
• [feat/refactor] AllColumns and AllTableColumns-Support for JSON_OBJECT by @ANeumann82 in https://github.com/JSQLParser/JSqlParser/pull/2323
• Update README.md by @hayssams in https://github.com/JSQLParser/JSqlParser/pull/2331
• feat: add PostgreSQL Row Level Security (RLS) support by @eyalge-gong in https://github.com/JSQLParser/JSqlParser/pull/2345
• [fix] Enable qualified table name for DROP INDEX command by @tonhuisman in https://github.com/JSQLParser/JSqlParser/pull/2344
• [fix] Add 'K_DATA' to KeywordOrIdentifier to allow usages of 'data' as an identifier by @willneedham93 in https://github.com/JSQLParser/JSqlParser/pull/2340
• Support PostgreSQL-specific [CREATE SEQUENCE name START n ...] by @mjog in https://github.com/JSQLParser/JSqlParser/pull/2348
• refactor: deprecate Join.getRightItem() and remove duplicate call by @zhezzz in https://github.com/JSQLParser/JSqlParser/pull/2370
• Add support for JOIN FETCH by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2375
• Add support for ClickHouse MATERIALIZED column in CREATE TABLE by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2377
• Add support for ClickHouse PREWHERE clause by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2378
• [feat] Support for the legacy Postgres named parameter by @bigdream96 in https://github.com/JSQLParser/JSqlParser/pull/2374
• Add support for insert as row_alias by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2383
• Fix ALTER TABLE with a USING INDEX clause by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2384
• Add support clickhouse GLOBAL ANY/ALL JOIN syntax variants by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2385
• Fix oracle outer join case with nvl/coalesce by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2386
• Add support for multiple Trino JSON functions by @davyboyhayes in https://github.com/JSQLParser/JSqlParser/pull/2382
• Fix alter table index descending by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2387
• Add support MySQL SPATIAL KEY by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2388
• Fix broken maven central svg url by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2389
• Add support SELECT SAMPLE 0.1/OFFSET and CREATE TABLE SAMPLE BY by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2390
• Add support MySQL named UNIQUE index in ALTER TABLE by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2391
• fix: support SQL Server ORDER BY ... FOR XML PATH parsing in subqueries by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2392
• fix: support ClickHouse parametric aggregate calls by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2393
• feat: add support for Oracle INSERT ALL/FIRST with WHEN branches by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2394
• fix(clickhouse): support SELECT ... SETTINGS by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2395
• feat: support EXPLAIN for DML and simplify ExplainStatement by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2396
• feat: support PostgreSQL 18 RETURNING OLD/NEW by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2398
• fix(parser): resolve grammar LOOKAHEAD conflicts by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2399
• Add support CREATE SEQUENCE AS data type by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2400
• Add support parse SEARCH BREADTH/DEPTH FIRST in recursive CTEs by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2402
• fix: restore GENERATED ALWAYS AS IDENTITY parsing by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2397
• Fix nested PostgreSQL composite field access after cast by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2404
• Add support MySQL functional index key parts in ALTER/CREATE INDEX by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2405
• fix(parser): support KEY-prefixed expressions like KEY chain.entity by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2409
• Fix dollar-quoted CREATE FUNCTION statement splitting by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2410
• fix(parser): parse mysql fulltext AGAINST concat expression by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2413
• test: add regression for ALTER TABLE MODIFY COLUMN CHARACTER SET by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2415
• Add support MySQL SELECT INTO OUTFILE/DUMPFILE by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2418
• fix(parser): pass modifier to ExceptOp/MinusOp constructors (#2419) by @queelius in https://github.com/JSQLParser/JSqlParser/pull/2420
• [feat] Support for JSON_TABLE by @ANeumann82 in https://github.com/JSQLParser/JSqlParser/pull/2328
• fix: split CCJSqlParserTokenManager static initializers to avoid 64KB… by @hayssams in https://github.com/JSQLParser/JSqlParser/pull/2425
• Enhance FOR UPDATE support by @rrobetti in https://github.com/JSQLParser/JSqlParser/pull/2426
• [Fix] #2443 - NPE In TableNamesFinder with AnalyticExpression by @davyboyhayes in https://github.com/JSQLParser/JSqlParser/pull/2444
• use Locale.ROOT for case-insensitive keyword normalisation by @dxbjavid in https://github.com/JSQLParser/JSqlParser/pull/2437
• Add support PostgreSQL ROWS FROM table functions by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2416
• fix: add 'K_TYPE' to KeywordOrIdentifier to allow 'type' as a column name by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2448
• fix: support nested parametric data types as CAST target by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2451
• fix: accept VISIBLE/INVISIBLE index and column attributes in CREATE TABLE and CREATE INDEX by @aparajon in https://github.com/JSQLParser/JSqlParser/pull/2449
• fix: allow arbitrary column aliases in LATERAL VIEW by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2452
• fix: stop 0x hex literal from swallowing trailing whitespace (#2435) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2450
• feat: support MERGE ... WHEN NOT MATCHED BY TARGET / BY SOURCE (#2421) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2453
• fix: support ClickHouse tuple positional access by @jianjindream in https://github.com/JSQLParser/JSqlParser/pull/2454
• feat: add support for the XMLTABLE table function by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2458
• fix: allow UNIQUE INDEX in CREATE TABLE by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2457
• fix(parser): keep parenthesized multi-param lambda as first function arg by @ivanclarksoft in https://github.com/JSQLParser/JSqlParser/pull/2455
• fix: support PostgreSQL GROUPS window frames by @jianjindream in https://github.com/JSQLParser/JSqlParser/pull/2460
• fix: model interval qualifier as a structured property by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2456
• fix: support SQL Server CREATE INDEX INCLUDE columns by @jianjindream in https://github.com/JSQLParser/JSqlParser/pull/2462
• fix: support PostgreSQL composite row expansion (function()).* by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2463
• fix: allow scalar subquery as LIMIT row count (#2359) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2464
• fix: support ClickHouse C-style ternary operator (? :) (#2436) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2466
• fix: support ClickHouse ORDER BY WITH FILL and INTERPOLATE (#2467) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2469
• fix: allow GROUPS as identifier by making it a non-reserved keyword (#2473) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2474
• feat: support SQL Server OPTION query hints (#161) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2472
• feat: support CREATE DATABASE (#2070) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2471
• fix: do not treat a named parameter ':' as the ternary else separator (#2475) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2476
• fix: treat a positional parameter '?' as a valid end of the ternary then-branch by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2477
• fix: reject illegal MERGE WHEN NOT MATCHED clause pairings (#2480) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2481
• fix: complete TablesNamesFinder traversal for piped queries, DML side clauses and analytic functions (#2478) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2479
• feat(parser): add support for ClickHouse [LEFT] ARRAY JOIN syntax by @watashi-00 in https://github.com/JSQLParser/JSqlParser/pull/2482
• fix: keep all clauses when deparsing SELECT without FROM (#2483) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2484
• Separate JSON operators with spaces so #> deparses correctly by @dngr2 in https://github.com/JSQLParser/JSqlParser/pull/2487
• feat: complete SQL Server OPTION query hint support by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2486
• feat: parse BigQuery JSON string literals as implicit casts by @hayssams in https://github.com/JSQLParser/JSqlParser/pull/2488
• fix: support Oracle inline constraint states in CREATE TABLE by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2491
• avoid quadratic backtracking when parsing bracketed server names by @dxbjavid in https://github.com/JSQLParser/JSqlParser/pull/2489
• feat(parser): support MySQL PROCEDURE ANALYSE clause by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2492
• fix: support character set introduced string literals by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2493
• fix(parser): support IF EXISTS in ALTER TABLE MODIFY COLUMN by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2494
• feat(parser): support DuckDB MAP literals and PIVOT queries by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2496
• avoid quadratic backtracking in the oracle hint comment pattern by @dxbjavid in https://github.com/JSQLParser/JSqlParser/pull/2495
• fix(parser): support Oracle USING INDEX TABLESPACE in ALTER TABLE ADD CONSTRAINT by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2498
• fix(parser): support CHARACTER SET in CAST CHAR types by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2497
• fix(parser): support leading CONTENT/DOCUMENT keyword in XMLPARSE by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2501
• fix(parser): support MySQL index options and prefix-length key parts in index DDL by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2505
• fix(parser): support PostgreSQL # binary operator (bitwise XOR / geometric intersection) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2507
• fix(parser): support CAST to an array type for MySQL multi-valued indexes by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2506
• fix(parser): parse qualified columns in GROUP BY by @jianjindream in https://github.com/JSQLParser/JSqlParser/pull/2504
• feat(parser): support MySQL # line comments behind allowHashLineComments by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2508
• feat(parser): turn on the dialect's lexer feature preset in withDialect by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2511
• feat(parser): support double quoted string literals behind allowDoubleQuotedStrings by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2513
• feat(parser): concatenate adjacent string literals behind adjacentStringLiterals by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2514
• feat(parser): add BIGQUERY, DATABRICKS and SNOWFLAKE dialect presets by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2515
• fix: collect tables from all SELECT and DML trailing clauses in TablesNamesFinder by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2517
• fix: prevent bare partition columns from inheriting the previous item's value by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2518
• fix: memoize long-chain predicate walks behind a size threshold by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2520
• Add structured MySQL CREATE TABLE partition parsing by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2521
• Support PostgreSQL CREATE INDEX header variants by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2527
• Support MySQL CHECK constraint enforcement by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2528
• fix(parser): allow VERSION in ALTER column clauses by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2530
• fix(parser): model ALTER COLUMN nullability actions by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2529
• feat(parser): add column data type fragment parser by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2531
• fix(parser): model PostgreSQL declarative partitions by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2535
• fix(parser): model PostgreSQL CREATE INDEX clauses by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2536
• test: fail the build when TablesNamesFinder misses a visitor dispatch method by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2538
• feat(parser): model ColDataType precision and scale as structured properties by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2539
• fix(parser): distinguish MySQL constraint and index names by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2534
• fix(parser): preserve unique index comments in ALTER TABLE by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2533
• fix(parser): model MySQL column type modifiers by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2537
• Model MySQL ALTER TABLE partition operations by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2540
• Support structured MySQL table definitions by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2541
• Model MySQL ANALYZE TABLE statements by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2542
• Support MySQL ALTER TABLE rename variants by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2543
• Model MySQL CREATE SCHEMA options by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2544
• Model MySQL DROP object lists by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2545
• Model MySQL CREATE USER statements by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2546
• Model MySQL CREATE EVENT and ALTER EVENT by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2547
• Model MySQL CREATE TRIGGER statements by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2548
• feat(parser): enhance PostgreSQL CREATE POLICY support by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2549
• feat(parser): parse navigation chains after array subscripts by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2550
• fix(parser): parse INSERT ON CONFLICT after a join's trailing ON by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2551
• feat(parser): model PostgreSQL schema DDL clauses by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2552
• fix(parser): parse stacked NOT prefixes as nested NotExpression (#1170) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2556
• build: pin file.encoding so the Maven build works on Windows by @knutwannheden in https://github.com/JSQLParser/JSqlParser/pull/2565
• feat(parser): model PostgreSQL type domain and extension DDL by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2553
• Support PostgreSQL parenthesized EXPLAIN options by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2558
• Support Redshift materialized view BACKUP clauses by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2557
• Support SQL Server typed XML schema collections by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2559
• Support Oracle XMLSERIALIZE CONTENT and DOCUMENT forms by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2560
• Support SQL Server ALTER TABLE ADD DEFAULT constraints by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2561
• fix(parser): parse Oracle outer join operator (+) on BETWEEN operands (#672) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2564
• Support structured PostgreSQL publication and subscription DDL by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2554
• Support structured PostgreSQL role, privilege and trigger DDL by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2555
• fix(parser): parse COMMENT ON ... IS NULL as comment removal (#2562) by @sundongkim-dev in https://github.com/JSQLParser/JSqlParser/pull/2563
• Fix DISTINCT traversal and share optional select-item visits by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2577
• Analyse analytic and conversion functions with complete window traversal by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2579
• Validate data-modifying CTEs through statement validators by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2578
• Fix parseStatements failure propagation and executor cleanup by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2568
• Support SQL Server table variables through shared table references by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2581
• Preserve EXEC bind arguments and support OUTPUT parameters by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2580
• Support PostgreSQL conflict index elements, OVERRIDING USER and MERGE RETURNING by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2569
• Complete MySQL index options and share CREATE INDEX rendering by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2567
• Support ksqlDB window grace periods and EMIT FINAL by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2571
• Support PostgreSQL tagged dollar strings and preserve literal bodies by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2572
• Support Informix trailing constraint names and share constraint rendering by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2570
• Support SQL Server clustering on primary key and unique constraints by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2582
• Support recursive CTE CYCLE clauses and share recursive clause rendering by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2566
• Support MySQL SELECT INTO user variables and share INTO rendering by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2583
• Support dialect-specific CREATE INDEX definitions by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2586
• Support Oracle anonymous blocks and implicit procedure calls by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2592
• Align empty input handling for statement parsing by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2594
• Support Doris distribution hints and share JOIN rendering by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2584
• Resolve shadowed contextual keyword and data-type token warnings by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2597
• Classify ODBC timestamp interval arguments as time units by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2596
• Support opt-in legacy MySQL GROUP BY ordering by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2595
• Support CockroachDB ALTER PRIMARY KEY with structured hash options by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2585
• Structure SQL Server routine operations and table return types by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2593
• fix(parser): parse Oracle outer join operator (+) after LIKE / SIMILAR TO operands (#2598) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2600
• Support Teradata UPDATE FROM before SET with shared clause rendering by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2587
• Split PostgreSQL hash operators from adjacent identifiers by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2588
• Accept SQL Server CREATE TABLE trailing commas with shared element parsing by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2603
• Support PostgreSQL DO wrappers with preserved routine body literals by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2589
• Support SQL Server XML methods on subquery results by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2590
• fix(parser): preserve Oracle PRIOR position on all condition expressions (#2601) by @fudianchn in https://github.com/JSQLParser/JSqlParser/pull/2602
• Support SQL Server INSERT BULK declarations by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2591
• Support SQL Server boolean SET options with shared statement rendering by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2604
• Support SQL Server SET IDENTITY_INSERT with a structured table target by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2605
• fix: keep CREATE TABLE option tokens in sync with typed options by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2606
• fix: preserve structured column options when editing specifications by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2608
• fix: share expression-aware table constraint rendering by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2609
• feat: preserve ALTER COLUMN default expressions in the AST by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2611
• fix: traverse and deparse structured table partitions by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2610
• refactor: share PostgreSQL routine argument grammar by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2613
• fix: recognise set operation quantifiers written in any case by @knutwannheden in https://github.com/JSQLParser/JSqlParser/pull/2614
• fix: preserve ordered table elements through legacy list edits by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2607
• feat: reuse table constraint grammar for PostgreSQL ALTER ADD by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2612
• fix: span a binary condition's node from its left operand by @knutwannheden in https://github.com/JSQLParser/JSqlParser/pull/2615
• feat: preserve column default expressions in table definitions by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2616
• Support SQL large-object names through shared column type parsing by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2617
• Visit pipe expressions through shared deparser paths by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2618
• Support structured XMLFOREST arguments with aliases by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2619
• Preserve ASOF joins through shared join rendering by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2621
• Structure FOR PORTION intervals in UPDATE and DELETE by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2622
• Validate every UPDATE assignment through shared UpdateSet traversal by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2623
• Render DML RETURNING expressions through shared visitor handling by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2624
• Reuse common JOIN traversal when discovering UPDATE tables by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2625
• Share parser execution and preserve cancellation signals by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2626
• Protect shared dialect presets from external mutation by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2627
• Keep ALTER key accessors connected to structured index state by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2628
• Fix benchmark configuration and isolated parser class loading by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2629
• Render DML source clauses through shared visitor paths by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2630
• Clarify PostgreSQL DO support and verify the reported block by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2633

• @zhangconan made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2303
• @ldaIas made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2277
• @ANeumann82 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2321
• @hayssams made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2331
• @eyalge-gong made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2345
• @tonhuisman made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2344
• @willneedham93 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2340
• @mjog made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2348
• @zhezzz made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2370
• @bigdream96 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2374
• @queelius made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2420
• @rrobetti made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2426
• @dxbjavid made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2437
• @fudianchn made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2451
• @aparajon made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2449
• @jianjindream made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2454
• @ivanclarksoft made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2455
• @watashi-00 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2482
• @dngr2 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2487
• @knutwannheden made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2565
• @sundongkim-dev made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2563

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-5.3...jsqlparser-5.4

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-5.2...jsqlparser-5.3

• #2119 add support INSERT OVERWRITE PARTITION by @tt20061904 in https://github.com/JSQLParser/JSqlParser/pull/2135
• fix: allowing skyline keywords as columns, tables, etc. by @nicky6s in https://github.com/JSQLParser/JSqlParser/pull/2137
• feat: Adding coverage for Postgres "OVERRIDING SYSTEM VALUE" by @nicky6s in https://github.com/JSQLParser/JSqlParser/pull/2142
• feat: Support unknown keyword by @EmilyOng in https://github.com/JSQLParser/JSqlParser/pull/2141
• Support not equals operator with a hat by @ssteinhauser in https://github.com/JSQLParser/JSqlParser/pull/2153
• Added support for minus all; except all; intersect all; by @SunandaS76 in https://github.com/JSQLParser/JSqlParser/pull/2081
• Add more tests to TablesNamesFinderTest for SubqueryAliasesIssue1987 by @pinkfloyda in https://github.com/JSQLParser/JSqlParser/pull/2154
• IsNullExpression and IsBooleanExpression children are not visited in … by @SuperPat45 in https://github.com/JSQLParser/JSqlParser/pull/2180
• Add support for parsing MySQL DISCARD and IMPORT TABLESPACE DDL statements by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2198
• Add support for AllTableColumns in PrimaryExpression by @tomershay in https://github.com/JSQLParser/JSqlParser/pull/2197
• Allow specific keywords to be parsed as identifiers (fix issue with RENAME COLUMN) by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2203
• Add support for MySQL ALTER TABLE ... [DEFAULT] COLLATE [=] collation_name syntax by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2204
• Add parsing for ALTER TABLE tbl_name {DISABLE | ENABLE} KEYS by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2205
• feat: add support SELECT all columns from function result by @0xlianhu in https://github.com/JSQLParser/JSqlParser/pull/2207
• feat: support MySQL ALTER TABLE ... PARTITION BY syntax by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2210
• Add support for MySQL ALTER TABLE partition options in parser by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2211
• Add test case for ALTER TABLE with KEY_BLOCK_SIZE for MySQL by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2213
• Add MySQL Index Parsing Support for ALTER TABLE Statements by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2215
• Resolve parser choice conflicts by adjusting lookahead in index-related rules by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2217
• Add support for TableFunction [WITH OFFSET|ORDINALITY] by @davyboyhayes in https://github.com/JSQLParser/JSqlParser/pull/2219
• Add support for parsing MySQL ALTER TABLE statements with advanced options by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2223
• feat: enhance ALTER TABLE support with UNIQUE KEY and INVISIBLE index by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2234

• @tt20061904 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2135
• @EmilyOng made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2141
• @SunandaS76 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2081
• @pinkfloyda made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2154
• @SuperPat45 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2180
• @0xlianhu made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2207
• @davyboyhayes made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2219

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-5.1...jsqlparser-5.2

• Avoid private tokens to be white listed and allow any word character in token value by @ssteinhauser in https://github.com/JSQLParser/JSqlParser/pull/2044
• Resolve parsing error for CHARACTER SET and COLLATE in MySQL ALTER TABLE (issue 2027) by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2045
• fix truncate parsing to capture multiple tables by @nick-redfearn in https://github.com/JSQLParser/JSqlParser/pull/2048
• fix insert default values statements not parsing by @nicky6s in https://github.com/JSQLParser/JSqlParser/pull/2050
• chore adding extra details to unit test scenarios by @nicky6s in https://github.com/JSQLParser/JSqlParser/pull/2051
• feature/fix: parsing inserts/updates/delete within CTEs by @nicky6s in https://github.com/JSQLParser/JSqlParser/pull/2055
• chore removing system.out.println lines + minor clean up of unit test scripts by @nicky6s in https://github.com/JSQLParser/JSqlParser/pull/2060
• Exasol support by @ssteinhauser in https://github.com/JSQLParser/JSqlParser/pull/2046
• Unparenthesized SubSelect as FromItem by @ssteinhauser in https://github.com/JSQLParser/JSqlParser/pull/2073
• Skyline syntax (preferring clause) by @ssteinhauser in https://github.com/JSQLParser/JSqlParser/pull/2078
• Failure to parse query with PRIOR in select list by @hannes92 in https://github.com/JSQLParser/JSqlParser/pull/2083
• Fix parsing ALTER TABLE ... ADD COLUMNS (...) by @njaremko in https://github.com/JSQLParser/JSqlParser/pull/2087
• Fix issue 2090: Correctly parse LOCK clause in ALTER TABLE statements by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2095
• Fix issue 2089: Add parsing functionality for MySQL CONVERT TO statement by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2097
• Fix issue 2106: Add parsing functionality for MySQL ADD PARTITION and DROP PARTITION clauses in ALTER TABLE statements by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2107
• Fix issue 2106: Add parsing functionality for MySQL ADD PARTITION and DROP PARTITION clauses in ALTER TABLE statements(2) by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2108
• fix: Issue #2109 true and false value parsed as column instead of BooleanValue by @lucarota in https://github.com/JSQLParser/JSqlParser/pull/2110
• Fix issue 2106: Add parsing functionality for MySQL ALTER Table option statements by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2115
• Fix issue 2089: Enhance MySQL CONVERT Statement Parsing by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2117
• Fix issue 2118: Enhance MySQL ALTER TABLE Parsing by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2121
• fix: [FEATURE] TablesNamesFinder does not support CREATE VIEW #2123 by @cptnricard in https://github.com/JSQLParser/JSqlParser/pull/2124
• add support for MATERIALIZED in WITH clause by @tomershay in https://github.com/JSQLParser/JSqlParser/pull/2128
• feat: add support MATCH_ANY MATCH_ALL MATCH_PHRASE MATCH_PHRASE_PREFIX MATCH_REGEXP by @dengliming in https://github.com/JSQLParser/JSqlParser/pull/2132
• build(deps): bump org.junit.jupiter:junit-jupiter-engine from 5.11.3 to 5.11.4 by @dependabot in https://github.com/JSQLParser/JSqlParser/pull/2129
• Fix null exception in ExpressionVisitorAdapter with simple INTERVAL expression by @tomershay in https://github.com/JSQLParser/JSqlParser/pull/2133

• @ssteinhauser made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2044
• @minleejae made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2045
• @nick-redfearn made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2048
• @nicky6s made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2050
• @hannes92 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2083
• @njaremko made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2087
• @cptnricard made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2124
• @dengliming made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2132

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-5.0...jsqlparser-5.1

• feat: Salesforce SOQL INCLUDES and EXCLUDES operators by @lucarota in https://github.com/JSQLParser/JSqlParser/pull/1985
• Add module info by @bowbahdoe in https://github.com/JSQLParser/JSqlParser/pull/1998
• Add missing java.sql require by @bowbahdoe in https://github.com/JSQLParser/JSqlParser/pull/1999
• feat: Capture expression name part delimiters by @mountaincrab in https://github.com/JSQLParser/JSqlParser/pull/2001
• fix: set stringValue in DoubleValue.setValue by @Qnzvna in https://github.com/JSQLParser/JSqlParser/pull/2009
• support custom DeParser by @redkale in https://github.com/JSQLParser/JSqlParser/pull/2013
• feat: Allow OUTER keyword as function parameter name by @mountaincrab in https://github.com/JSQLParser/JSqlParser/pull/2021

• @lucarota made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1985
• @bowbahdoe made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1998
• @mountaincrab made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2001
• @Qnzvna made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2009
• @redkale made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2013

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-4.9...jsqlparser-5.0

• feat: support any number/order of merge operations by @davidjgoss in https://github.com/JSQLParser/JSqlParser/pull/1938
• feat: Build with Automatic-Module-Name for compatibility with the Java module system. by @broneill in https://github.com/JSQLParser/JSqlParser/pull/1941
• fix: ExpressionVisitor.visit(AllTableColumns) method isn't being called. by @broneill in https://github.com/JSQLParser/JSqlParser/pull/1942
• feat: support keyword "only" for postgresql by @SheldonKubor in https://github.com/JSQLParser/JSqlParser/pull/1952
• feat: support Informix keywords "with no log" by @SheldonKubor in https://github.com/JSQLParser/JSqlParser/pull/1953
• support oracle alter table truncate partition by @SheldonKubor in https://github.com/JSQLParser/JSqlParser/pull/1954
• fix: issue1875 by @SheldonKubor in https://github.com/JSQLParser/JSqlParser/pull/1957
• fix: tables not find in parentheses join sql. by @Hanchers in https://github.com/JSQLParser/JSqlParser/pull/1956
• fix: Fixes parsing failing for ALTER MODIFY queries not containing datatype by @Tanish0019 in https://github.com/JSQLParser/JSqlParser/pull/1961
• feat: add additional CREATE VIEW modifiers by @davidjgoss in https://github.com/JSQLParser/JSqlParser/pull/1964
• Guard Values against null/empty values by @pingpingy1 in https://github.com/JSQLParser/JSqlParser/pull/1965
• fix: make analytic expression visitor null-safe by @davidjgoss in https://github.com/JSQLParser/JSqlParser/pull/1944
• Handle select in ExpressionVisitorAdapter by @sivaraam in https://github.com/JSQLParser/JSqlParser/pull/1972

• @broneill made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1941
• @SheldonKubor made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1952
• @Hanchers made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1956
• @Tanish0019 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1961
• @pingpingy1 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1965

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-4.8...jsqlparser-4.9

• feat:support clickhouse global keyword in IN Expression by @herbert2008 in https://github.com/JSQLParser/JSqlParser/pull/1794
• add support for index hints in Update statement for MySQL by @joeqiao1984 in https://github.com/JSQLParser/JSqlParser/pull/1662
• added support for T-SQL left and right joins (= and =) by @nbauma109 in https://github.com/JSQLParser/JSqlParser/pull/738
• Unit tests support multi-os and higher versions of jdk by @human-user in https://github.com/JSQLParser/JSqlParser/pull/1886
• feat: add support for snowflake merge statements by @davidjgoss in https://github.com/JSQLParser/JSqlParser/pull/1887
• Fix typo in migration.rst by @esabol in https://github.com/JSQLParser/JSqlParser/pull/1888
• feat: Add support for REFRESH MATERIALIZED VIEW by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1911
• feat: Add support comment in create view for MySQL and MariaDb by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1913
• Fix conflict by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1915
• Fix: Support Drop Key by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1917
• Fix: mysql and mariadb can use index type before ON by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1918
• Fix: [MySQL] Add COMMENT for ALTER ADD by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1919
• feat: Support RENAME INDEX for MySQL, RENAME CONSTRAINT for PostgreSQL by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1920
• feat: [MySQL] Support TABLE STATEMENT by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1921
• feat: Support FOR SHARE by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1922
• feat: support mysql with rollup by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1923
• Fix: ALTER INDEX COMMENT by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1932
• Fix: DESC and EXPLAIN by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1933
• Fix: mysql comment with = by @jxnu-liguobin in https://github.com/JSQLParser/JSqlParser/pull/1936

• @herbert2008 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1794
• @joeqiao1984 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1662
• @nbauma109 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/738
• @human-user made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1886
• @davidjgoss made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1887
• @esabol made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1888
• @jxnu-liguobin made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1911

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-4.7...jsqlparser-4.8

This is an API breaking release! Please see the migration guide: https://jsqlparser.github.io/JSqlParser/migration.html Detailed Change Log: https://jsqlparser.github.io/JSqlParser/changelog.html

• Assorted Fixes #6 by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1740
• ignoring unnecessarily generated surefire report by @optimizing-ci-builds in https://github.com/JSQLParser/JSqlParser/pull/1748
• Assorted Fixes #7 by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1745
• Refactor Parenthesed SelectBody and FromItem by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1754
• Ignoring unnecessarily generated by pmd plugin by @optimizing-ci-builds in https://github.com/JSQLParser/JSqlParser/pull/1763
• Ignoring unnecessarily generated jacoco report by @optimizing-ci-builds in https://github.com/JSQLParser/JSqlParser/pull/1762
• Fix #1758: Use long for Feature.timeOut by @zaza in https://github.com/JSQLParser/JSqlParser/pull/1759
• JSQLParser 5.0 by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1778
• Assorted Fixes #8 by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1807
• Backslash Quotation of Single-Quote '\\'' by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1813
• feat: add support for INTERPRET function parsing by @matteosist in https://github.com/JSQLParser/JSqlParser/pull/1816
• Update Gradle JavaCC parser to latest version (3.0.0) by @zbynek in https://github.com/JSQLParser/JSqlParser/pull/1843
• Fixing a problem with an OP_CONCAT in WhenExpression by @amigalev in https://github.com/JSQLParser/JSqlParser/pull/1837

• @optimizing-ci-builds made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1748
• @matteosist made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1816
• @zbynek made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1843
• @amigalev made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1837

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-4.6...jsqlparser-4.7

• Using own Feature - constant for "delete with returning" #1597 by @gitmotte in https://github.com/JSQLParser/JSqlParser/pull/1598
• fix Issues: #1524 support hive alter sql : ALTER TABLE name ADD COLUMNS (col type,col2 type.....) by @Zhumin-lv-wn in https://github.com/JSQLParser/JSqlParser/pull/1605
• Fixes PR #1524 support hive alter sql by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1609
• Closes #1604, added simple OVERLAPS support by @d2a-raudenaerde in https://github.com/JSQLParser/JSqlParser/pull/1611
• Support timestamptz dateliteral by @tpoll in https://github.com/JSQLParser/JSqlParser/pull/1621
• fix: add missing public Getter by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1632
• Support BigQuery SAFE_CAST (#1622) by @dequn in https://github.com/JSQLParser/JSqlParser/pull/1634
• Bump h2 from 1.4.200 to 2.1.210 by @dependabot in https://github.com/JSQLParser/JSqlParser/pull/1639
• Assorted fixes by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1646
• Support for SKIP LOCKED tokens on SELECT FOR UPDATE statements by @lucasdillmann in https://github.com/JSQLParser/JSqlParser/pull/1649
• Enhanced Keywords by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1382
• Keywords2: Update whitelisted Keywords by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1653
• Fix parsing statements with multidimensional array PR2 by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1665
• Assorted fixes by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1666
• Fixed download war script in the renderRR task by @haha1903 in https://github.com/JSQLParser/JSqlParser/pull/1659
• Assorted Fixes #4 by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1676
• Fix #1686: add support for creating views with "IF NOT EXISTS" clause by @zaza in https://github.com/JSQLParser/JSqlParser/pull/1690
• Support DROP MATERIALIZED VIEW statements by @zaza in https://github.com/JSQLParser/JSqlParser/pull/1711
• Assorted Fixes #5 by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1715
• Sphinx Website by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1624
• Added support for SHOW INDEX from table by @jayant-kumar-yadav in https://github.com/JSQLParser/JSqlParser/pull/1704
• Issue1673 case within brackets by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1675
• Oracle Alternative Quoting by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1722

• @Zhumin-lv-wn made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1605
• @tpoll made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1621
• @dequn made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1634
• @lucasdillmann made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1649
• @haha1903 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1659
• @zaza made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1690
• @jayant-kumar-yadav made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1704

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-4.5...jsqlparser-4.6

• UnsupportedStatement support instead of throwing Exceptions
• support for RETURNING clause of a DELETE statement
• Add support for ... ALTER COLUMN ... DROP DEFAULT
• INSERT supports SetOperations (e. g. INSERT INTO ... SELECT ... FROM ... UNION SELECT ... FROM ...), those SetOperations are used both for SELECT and VALUES clauses (API change) in order to simplify the Grammar
• (WITH ... SELECT ...) statements within brackets are now supported
• Postgres NATURAL { INNER | LEFT | RIGHT } JOIN support
• extended support for Hive dialect GROUPING SETS
• support for Postgresql drop function
• support table option character set and index options
• support Postgresql optional TABLE in TRUNCATE
• support for ANALYZE mytable
• PostgreSQL INSERT INTO ... ON CONFLICT ... DO ... statements
• implement Parser Timeout Feature, e. g. CCJSqlParserUtil.parse(sqlStr, parser -> parser.withTimeOut(60000));
• extended support Postgres' Extract( field FROM source) where field is a String instead of a Keyword
• support for DROP column IF EXISTS

• Performance Improvements by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1439
• Update bug_report.md by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1512
• Unsupported statement by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1519
• fixs #1520 by @chiangcho in https://github.com/JSQLParser/JSqlParser/pull/1521
• #1527 DELETE ... RETURNING ... by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1528
• Add support for ... ALTER COLUMN ... DROP DEFAULT by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1532
• #1516 rename without column keyword by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1533
• INSERT with SetOperations by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1531
• Allow isolation keywords as column name and aliases by @tomershay in https://github.com/JSQLParser/JSqlParser/pull/1534
• compound statement tests by @rathboma in https://github.com/JSQLParser/JSqlParser/pull/1545
• Postgres NATURAL LEFT/RIGHT joins by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1560
• Add support for Hive dialect GROUPING SETS. by @qzchenwl in https://github.com/JSQLParser/JSqlParser/pull/1539
• add support for postgres drop function statement by @rrrship in https://github.com/JSQLParser/JSqlParser/pull/1557
• Add test for LikeExpression.setEscape and LikeExpression.getStringExpression by @lacinoire in https://github.com/JSQLParser/JSqlParser/pull/1568
• Support table option character set and index options by @luoffei in https://github.com/JSQLParser/JSqlParser/pull/1586
• Closes #1583:: Implement Postgresql optional TABLE in TRUNCATE by @d2a-raudenaerde in https://github.com/JSQLParser/JSqlParser/pull/1585
• Closes #1579. Added ANALYZE support. by @d2a-raudenaerde in https://github.com/JSQLParser/JSqlParser/pull/1587
• Extended support Postgres' Extract( field FROM source) by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1591
• Configurable Parser Timeout via Feature by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1592
• PostgreSQL INSERT ... ON CONFLICT Issue #1551 by @manticore-projects in https://github.com/JSQLParser/JSqlParser/pull/1552
• add support for drop column if exists by @rrrship in https://github.com/JSQLParser/JSqlParser/pull/1594

New Contributors

• @rathboma made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1545
• @qzchenwl made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1539
• @rrrship made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1557
• @lacinoire made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1568
• @luoffei made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1586
• @d2a-raudenaerde made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/1585

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-4.4...jsqlparser-4.5