GeezerVison

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 pa...

Contributors

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

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

Contributors

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

Contributors

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

Contributors

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

Contributors

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

Contributors

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

Contributors

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

Contributors

• 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

Contributors