Release notes from JSqlParser

jsqlparser-5.4

2026-09-13T22:12:17Z

What's Changed

Changes and new Features

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

New Contributors

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

Full Changelog: jsqlparser-5.3...jsqlparser-5.4

jsqlparser-5.3

2025-05-17T23:52:30Z

Full Changelog: jsqlparser-5.2...jsqlparser-5.3

jsqlparser-5.2

2025-05-04T22:35:03Z

What's Changed

Changes and new Features

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

New Contributors

@tt20061904 made their first contribution in #2135
@EmilyOng made their first contribution in #2141
@SunandaS76 made their first contribution in #2081
@pinkfloyda made their first contribution in #2154
@SuperPat45 made their first contribution in #2180
@0xlianhu made their first contribution in #2207
@davyboyhayes made their first contribution in #2219

Full Changelog: jsqlparser-5.1...jsqlparser-5.2

jsqlparser-5.1

2025-01-02T00:45:55Z

What's Changed

Changes and new Features

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

New Contributors

@ssteinhauser made their first contribution in #2044
@minleejae made their first contribution in #2045
@nick-redfearn made their first contribution in #2048
@nicky6s made their first contribution in #2050
@hannes92 made their first contribution in #2083
@njaremko made their first contribution in #2087
@cptnricard made their first contribution in #2124
@dengliming made their first contribution in #2132

Full Changelog: jsqlparser-5.0...jsqlparser-5.1

jsqlparser-5.0

2024-06-30T21:06:54Z

What's Changed

Changes and new Features

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

New Contributors

@lucarota made their first contribution in #1985
@bowbahdoe made their first contribution in #1998
@mountaincrab made their first contribution in #2001
@Qnzvna made their first contribution in #2009
@redkale made their first contribution in #2013

Full Changelog: jsqlparser-4.9...jsqlparser-5.0

jsqlparser-4.9

2024-03-09T22:22:00Z

What's Changed

Changes and new Features

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

New Contributors

@broneill made their first contribution in #1941
@SheldonKubor made their first contribution in #1952
@Hanchers made their first contribution in #1956
@Tanish0019 made their first contribution in #1961
@pingpingy1 made their first contribution in #1965

Full Changelog: jsqlparser-4.8...jsqlparser-4.9

jsqlparser-4.8

2023-12-28T00:35:28Z

What's Changed

Changes and new Features

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

New Contributors

@herbert2008 made their first contribution in #1794
@joeqiao1984 made their first contribution in #1662
@nbauma109 made their first contribution in #738
@human-user made their first contribution in #1886
@davidjgoss made their first contribution in #1887
@esabol made their first contribution in #1888
@jxnu-liguobin made their first contribution in #1911

Full Changelog: jsqlparser-4.7...jsqlparser-4.8

jsqlparser-4.7

2023-09-02T05:26:16Z

New API

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

What's Changed

Changes and new Features

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

New Contributors

@optimizing-ci-builds made their first contribution in #1748
@matteosist made their first contribution in #1816
@zbynek made their first contribution in #1843
@amigalev made their first contribution in #1837

Full Changelog: jsqlparser-4.6...jsqlparser-4.7

jsqlparser-4.6

2023-02-23T21:44:54Z

What's Changed

Changes and new Features

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

New Contributors

@Zhumin-lv-wn made their first contribution in #1605
@tpoll made their first contribution in #1621
@dequn made their first contribution in #1634
@lucasdillmann made their first contribution in #1649
@haha1903 made their first contribution in #1659
@zaza made their first contribution in #1690
@jayant-kumar-yadav made their first contribution in #1704

Full Changelog: jsqlparser-4.5...jsqlparser-4.6

jsqlparser-4.5

2022-07-22T22:59:12Z

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

What's Changed

Changes and new Features

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

New Contributors

@rathboma made their first contribution in #1545
@qzchenwl made their first contribution in #1539
@rrrship made their first contribution in #1557
@lacinoire made their first contribution in #1568
@luoffei made their first contribution in #1586
@d2a-raudenaerde made their first contribution in #1585

Full Changelog: jsqlparser-4.4...jsqlparser-4.5