v0.5.1

What's Changed

• Add support for window names in WindowExpr by @chinhnguyenh in #259
• Fix panic on invalid number as query, add guard against invalid lastToken by @disq in #260
• Support COMMENT before AS SELECT in CREATE MATERIALIZED VIEW by @sharadgaur in #262
• Add support for CREATE USER VALID UNTIL clause by @git-hulk in #264
• feat: add COMMENT support to CREATE VIEW parser by @sharadgaur in #265

New Contributors

• @chinhnguyenh made their first contribution in #259

Full Changelog: v0.5.0...v0.5.1

v0.5.0

What's Changed

• Add support for nested named/unnamed tuple types by @rhino1998 in #233
• Add support for CREATE NAMED COLLECTION statements (#235) by @St0rmPetrel in #236
• Add line break and indentation to FROM clause formatting by @Copilot in #244
• Add line break before column list in INSERT INTO formatting by @Copilot in #246
• Add line break and indentation for SETTINGS clause in beautify mode by @Copilot in #245
• Add beautify format support for CREATE USER statements by @Copilot in #247
• Add chaining methods to formatter for customizable indentation by @Copilot in #248
• Document -beautify flag with example by @Copilot in #249
• Add line breaks for ON CLUSTER and ALTER clauses in beautify mode by @Copilot in #251
• Add beautify format support for CREATE DICTIONARY statements by @Copilot in #253
• fix: support expressions (dotted column refs) in DISTINCT ON by @disq in #258

New Contributors

• @St0rmPetrel made their first contribution in #236
• @disq made their first contribution in #258

Full Changelog: v0.4.19...v0.5.0

v0.4.19

What's Changed

• Add support for OFFSET clause without LIMIT by @rhino1998 in #226
• Fix workflow does not contain permissions by @git-hulk in #227
• Add support for concat operator by @rhino1998 in #228
• Fix support for multiple array join statements by @hermanschaaf in #229
• Allow ARRAY JOIN to be interleaved with other JOIN statements by @hermanschaaf in #230
• Fix CASE statement WHEN spacing by @rhino1998 in #231
• Add support for SETTINGS clause in ALTER TABLE ADD COLUMN by @Lance726 in #232
• Fix parsing failure when having multiple ttl expressions by @git-hulk in #234

New Contributors

• @rhino1998 made their first contribution in #226
• @hermanschaaf made their first contribution in #229

Full Changelog: v0.4.18...v0.4.19

v0.4.18

What's Changed

• Fix efreshable View with named parameters by @sharadgaur in #217
• Fix Send error messages to stderr instead of stdout by @Copilot in #221
• Fix regex expression wasn't allowed in EXTRACT by @git-hulk in #223
• Support empty parentheses in index type definitions by @Lance726 in #224
• Add support for parsing Tuple type in DDL by @git-hulk in #225

Full Changelog: v0.4.17...v0.4.18

v0.4.17

What's Changed

• Fix string escape sequences in lexer by @waterdrag0n in #209
• Add COMMENT support for CREATE DICTIONARY DDL statements by @sharadgaur in #210
• Add WITH FILL Support in ORDER BY by @Flo4604 in #211
• Parse compression codecs with no parameters by @swgillespie in #197
• Fix nil pointer for replicated database engine by @rabenhorst in #212
• Add support of parsing SETTING boolean values by @mdevilliers in #213
• Add support for table functions in CREATE TABLE AS statements by @swgillespie in #214
• Fix a crash with an invalid query following MODIFY QUERY by @swgillespie in #215

New Contributors

• @waterdrag0n made their first contribution in #209
• @Flo4604 made their first contribution in #211
• @swgillespie made their first contribution in #197
• @rabenhorst made their first contribution in #212
• @mdevilliers made their first contribution in #213

Full Changelog: v0.4.15...v0.4.17

v0.4.15

What's Changed

• Fix the printing order of the EngineExpr.String() method by @whscout in #201
• parser: fix typed placeholder lookahead; parse WHERE in SELECT without FROM by @ajruckman in #202
• parser: support ALTER TABLE DELETE/UPDATE mutations by @ajruckman in #203
• Allow to use the optional IN PARTITION expression in ALTER TABLE by @git-hulk in #206
• parser: QBit data type support via simplified identifier handling by @ajruckman in #207
• Support multiple WINDOW definitions; expand window function tests by @ajruckman in #208

New Contributors

• @whscout made their first contribution in #201
• @ajruckman made their first contribution in #202

Full Changelog: v0.4.14...v0.4.15

0.4.14

What's Changed

• Fix parsing on multiple union distinct and except by @erezrokah in #192
• Fix should allow using keywords as alias for columns by @erezrokah in #193
• Add support for SELECT DISTINCT ON(…) by @bripkens in #194
• Fix Walk logic for DistinctOn clause by @git-hulk in #195
• Adding type hint parsing in JSON column type by @piyushsingariya in #196
• Support single-quoted table names. by @marianogappa in #199
• Handle select keyword inside functions by @erezrokah in #200

New Contributors

• @bripkens made their first contribution in #194
• @piyushsingariya made their first contribution in #196
• @marianogappa made their first contribution in #199

Full Changelog: v0.4.13...v0.4.14

v0.4.13

What's Changed

• Fix INDEX column spacing bug by @sharadgaur in #186
• Allow using JSON path in select results by @git-hulk in #189
• Fix shouldn't stop on nil values when traversing the AST by @erezrokah in #191
• fix: Fix Walk logic for When clause by @erezrokah in #190

New Contributors

• @erezrokah made their first contribution in #191

Full Changelog: v0.4.11...v0.4.13

0.4.11

What's Changed

• feat: support for ALTER TABLE MODIFY QUERY by @Blackmorse in #168
• fix: ParamExprList.String is missing ColumnArgList by @keuin in #169
• Add support of parsing database comment by @caifengyin in #167
• Implement OR REPLACE clause support for CREATE FUNCTION statements by @Copilot in #171
• Export Enter and Leave methods in ASTVisitor interface by @Copilot in #172
• Add support for CREATE USER statement according to ClickHouse SQL documentation by @Copilot in #170
• fix: change WINDOW clause position by @Blackmorse in #173
• Remove an extra leading space when formatting the WINDOW FUNCTION by @git-hulk in #174
• Add support for CREATE DICTIONARY statement by @Copilot in #175
• Add support of PROJECTION column in CREATE TABLE by @git-hulk in #178
• Add support for SHOW and DESC/DESCRIBE statements by @Copilot in #180
• Enhance SHOW DATABASES statement to support LIKE, ILIKE, LIMIT, OUTFILE, and FORMAT clauses by @Copilot in #182
• Support DESCRIBE TABLE syntax by @dejanmltc in #183
• feat: Add ALTER TABLE MODIFY/RESET SETTING syntax support by @git-hulk in #185

New Contributors

• @Blackmorse made their first contribution in #168
• @keuin made their first contribution in #169
• @caifengyin made their first contribution in #167
• @Copilot made their first contribution in #171
• @dejanmltc made their first contribution in #183

Full Changelog: v0.4.10...v0.4.11

v0.4.10

What's Changed

• Adding support MV definer by @sharadgaur in #160
• Preserve DISTINCT keyword when it appears right after SELECT by @anshal21 in #161
• Improve statement end position handling to prevent null pointer exceptions by @Lance726 in #162
• Support JSON parameter for max_dynamic_paths and max_dynamic_types by @Junrin-Lee in #164
• Add MILLISECOND to time interval units by @vvkohut in #166

New Contributors

• @Junrin-Lee made their first contribution in #164
• @vvkohut made their first contribution in #166

Full Changelog: v0.4.9...v0.4.10