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