CHANGELOG.md

Changelog

12.7.1 (2024-12-17)

Bug Fixes

• extractStatementsUsingAutocomplete sometimes not working on semicolon (#260) (5a672ca)

12.7.0 (2024-12-13)

Features

• YQL: support variables and scopes (#258) (2406c4d)

12.6.0 (2024-12-09)

Features

• expand export types (#256) (38f54e4)

12.5.0 (2024-12-03)

Features

• Implement extractStatementPositions for MongoDB (#254) (c783892)
• Partial support of mongo dialect and commands extractor (#252) (6831e27)
• Support all find/insert commands for MongoDB (#255) (3ae2b51)

12.4.2 (2024-11-22)

Bug Fixes

• add trino to package exports 2 (#250) (688308e)

12.4.1 (2024-11-22)

Bug Fixes

• add trino to exports (#248) (d6a92b6)

12.4.0 (2024-11-22)

Features

• trino autocomplete (#245) (d37ba50)
• upgrade trino autocomplete (#247) (350c1d3)

12.3.0 (2024-11-14)

Features

• Improve SELECT command for ClickHouse (#243) (81968db)

12.2.0 (2024-11-11)

Features

• Allow to set any value after FORMAT TYPE for INSERT command in ClickHouse (#240) (b315855)
• Support settings clause for DELETE command in ClickHouse (#241) (5ddd428)

12.1.2 (2024-11-08)

Bug Fixes

• package.json: improve exports section (#238) (7f23ab1)

12.1.1 (2024-11-08)

Bug Fixes

• YQL: explicitely export types (#236) (4d1989b)

12.1.0 (2024-11-07)

Features

• Improve ALTER command for ClickHouse (#233) (3b8e2e1)
• YQL: support UPSERT and all columns suggestions (#234) (037ef37)

12.0.0 (2024-11-06)

⚠ BREAKING CHANGES

• rename startIndex to column in tokenize (#216)

Features

• Improve INSERT command for ClickHouse (#230) (0208d51)
• Support all create commands (#231) (4d923cd)
• support extract statements api (#216) (a01b941)
• Support grant command for Clickhouse (#227) (4902a69)
• Support revoke command/grant command improvements for Clickhouse (#229) (80f32b0)
• YQL: update grammar (#232) (b0d0f35)
• support extract statements api (#216)

Bug Fixes

• decimal in Redis lexer (#225) (5c3469a)

11.0.0 (2024-09-12)

⚠ BREAKING CHANGES

• support most Redis string commands, rename suggestKeys to suggestStrings (#217)

Features

• support most Redis common commands (#219) (d865ed6)
• support most Redis list commands, add suggestLists to autocomplete (#220) (ad85bef)
• support most Redis string commands, rename suggestKeys to suggestStrings (#217) (a21f79b)
• support Redis hash commands, add suggestHashes to autocomplete (#223) (2811872)
• support Redis set commands, add suggestSets to autocomplete (#221) (f0291da)
• support Redis sorted set commands, add suggestSortedSets to autocomplete (#222) (1b2b39c)

10.3.0 (2024-08-16)

Features

• support cjs build (#214) (e1ae899)

10.2.1 (2024-08-13)

Bug Fixes

• export shared types (#211) (9195b95)

10.2.0 (2024-08-13)

Features

• add ability to extract redis commands from query (#210) (06520f7)
• add Redis autocomplete (#209) (41199c8)
• basic Redis grammar, parseRedisQueryWithoutCursor function (#207) (584f902)

10.1.0 (2024-07-23)

Features

• YQL: add tokenize method for YQL (#205) (8c2f69a)

10.0.0 (2024-07-09)

⚠ BREAKING CHANGES

• modular assembly (#202)

9.1.1 (2024-06-26)

Bug Fixes

• add option to esbuild to prevent constructor names being changed, causing conflicts in parsers (#198) (987468a)

9.1.0 (2024-06-06)

Features

• YQL: suggest simple types in expressions (#194) (6c81be6)

9.0.0 (2024-06-04)

⚠ BREAKING CHANGES

• YQL: rename suggestTableSettings to suggestEntitySettings with type YQLEntity (#192) (fb478ce)

8.4.0 (2024-05-31)

Features

• YQL: add table settings suggestions (#190) (fb450be)

8.3.0 (2024-05-31)

Features

• YQL: suggest view and external table in select statements (#188) (416248c)

8.2.0 (2024-05-30)

Features

• YQL: improve suggestions calculation (#184) (71e9056)

8.1.0 (2024-05-02)

Features

• suggest multiple tables with same name and different aliases (#182) (1d3fb82)

8.0.2 (2024-03-13)

Bug Fixes

• YQL: should not suggest columns after FROM keyword (#179) (df467c5)

8.0.1 (2024-03-11)

Bug Fixes

• should not suggest excess keywords if entity id equals to keyword in YQL autocomplete (#177) (23de65a)

8.0.0 (2024-03-11)

⚠ BREAKING CHANGES

• Support YQ dialect (#173)

Features

• Support YQ dialect (#173) (24f51be)

Bug Fixes

• rename YQ and YQL functions (#175) (2d1feef)

7.0.0 (2024-03-06)

⚠ BREAKING CHANGES

• Add YQL language autocomplete (#170)

Features

• Add YQL language autocomplete (#170) (7f07f3e)

6.1.0 (2024-03-05)

Features

• Add role suggestions for MySql (#165) (eba7ac3)
• Add user suggestions for MySql, role suggestions for PostgreSql (#168) (f329f54)

6.0.0 (2024-02-28)

⚠ BREAKING CHANGES

• add table context to constraint suggestions (#159)

Features

• add table context to constraint suggestions (#159) (23ee8dd)

5.1.0 (2024-02-28)

Features

• Add database suggestions (#161) (eaba501)
• Add schema suggestions for postgresql (#157) (ceb9580)

Bug Fixes

• Properly export specific database autocomplete results (#152) (b426a40)

5.0.0 (2024-02-21)

⚠ BREAKING CHANGES

• separate AutocompleteParseResult for different databases (#148)

Features

• separate AutocompleteParseResult for different databases (#148) (34d5a2b)

4.3.0 (2024-02-19)

Features

• add trigger suggestions to mysql, postgresql (#139) (f09f472)

Bug Fixes

• fix 'DROP INDEX test_index |' suggesting even more indexes (#142) (36d92fb)

4.2.0 (2024-02-16)

Features

• support suggestIndexes in AutocompleteParseResult (#138) (87fc174)

Bug Fixes

• broken psql super class throwing errors on function creation (#136) (c86c4a4)
• postgresql alter view columns suggestions (#134) (ed60a24)

4.1.0 (2024-02-15)

Features

• suggest column aliases (#127) (2f338ca)

4.0.1 (2024-02-13)

Bug Fixes

• package name (#124) (a754194)

4.0.0 (2024-02-13)

⚠ BREAKING CHANGES

• New version of autocomplete based on code completion on ANTLR4 grammars

3.0.0 (2023-12-07)

⚠ BREAKING CHANGES

• Update interfaces, rename generic sql parser to mysql (#118)

Bug Fixes

• make engine text reliable (#109) (ad88671)
• remove duplicate SubQuery interface (#113) (4510693)

2.1.0 (2023-12-05)

Features

• add CommonSuggestion and JoinsSuggestion types, migrate postgresql tests to typescript (#105) (36b291c)
• add eslint ci, fix eslint errors (#97) (2c66e7a)
• define database StatementPart, add identifierChain to TablesSuggestion, remove useless totos, migrate drop tests to typescript (#96) (47a18c2)
• define FiltersSuggestion, FunctionsSuggestion, ValuesSuggestion, Colref, migrate update table tests to typescript (#99) (4b99563)
• define suggestColRefKeywords, suggestEngines, add typechecking ci (#95) (f09f370)
• define useDatabase, add prependQuestionMark and prependFrom to DatabasesSuggestion, migrate use and set tests to typescript (#101) (7ec60ae)
• extend StatementPart, make TestCase fields optional, migrate location tests to typescript and move files to select folder (#107) (8b6b2c4)
• migrate truncate table tests to typescript (#102) (7d7d38b)
• move AggregateFunctionsSuggestion to a separate interface, refactor general parser create tests (#92) (08e8c26)
• type generator and move to single package.json (#93) (a5ac8e9)
• update parse result types, properly type parser-extension (#103) (8dcaf65)

2.0.0 (2023-11-28)

⚠ BREAKING CHANGES

• rename sql-autocomplete-parsers to websql-autocomplete (#88)

Features

• rename sql-autocomplete-parsers to websql-autocomplete (#88) (123d585)

1.22.0 (2023-09-05)

Features

• actualise clickhouse data types (#82) (e16505a)

1.21.0 (2023-08-11)

Features

• Support CREATE TABLE with ENGINE syntax for ClickHouse (#78) (759b642)

1.20.0 (2023-08-10)

Features

• Support non-ordered LIMIT and OFFSET (#76) (049a46e)

1.19.0 (2023-08-09)

Features

• Support OFFSET for PostgreSQL (#71) (7834158)

1.18.0 (2023-08-08)

Features

• Separate PostgreSQL parser (#69) (a005dce)

1.17.0 (2023-08-07)

Features

• handle UPDATE errors with SET (#65) (ceb0dff)

1.16.0 (2023-08-07)

Features

• Handle errors for INSERT template (#62) (c6af390)

1.15.0 (2023-07-26)

Features

• Column suggestions for INSERT query (#60) (fd02a6b)

1.14.0 (2023-07-24)

Features

• Support column names syntax for INSERT query (#58) (d95843a)

1.13.0 (2023-07-14)

Features

• move npm ci installation for generator to a script (#54) (dadded4)
• remove postinstall script, update readme.md (#53) (2ac6e20)
• restore postinstall script, make it execute only when we're not installed as dependency (#56) (16a7efb)

1.12.0 (2023-07-14)

Features

• remove debug field from Parser.parseSql (#51) (304cc96)

1.11.0 (2023-07-11)

Features

• specify locations in ParseResult (#48) (bf348b8)

1.10.0 (2023-07-10)

Features

• expand suggestTables interface (#45) (e312358)

1.9.0 (2023-07-07)

Features

• add and integrate suggestSnippet method (#43) (f1eb102)

1.8.0 (2023-06-23)

Features

• support explain statement (#30) (27aef7c)

1.7.0 (2023-06-21)

Features

• specify type for ParseResult.suggestAggregateFunctions (#33) (b9e9dbd)
• specify type for suggestColumnAliases (#36) (d18fcd3)

1.6.1 (2023-06-15)

Bug Fixes

• fix column suggestions for delete statement (#27) (7d5c916)

1.6.0 (2023-06-07)

Features

• add newline just for the release (#25) (cc95a05)

1.5.0 (2023-06-06)

Features

• add delete statement suggestions (34f22e0), (d4ba052)

1.4.0 (2023-06-06)

Features

• add alias for table interface (12920a3)

1.3.0 (2023-06-06)

Features

• expand ParseResult interface (7235b0d)

1.2.0 (2023-06-05)

Features

• support 'DELETE FROM mytable' for genericAutocompleteParser (65e0c06)

1.1.1 (2023-06-01)

Bug Fixes

• ts-ignore genericAutocompleteParser import (8590b60)

1.1.0 (2023-06-01)

Features

• bump version (d0c0038)

1.0.0 (2023-06-01)

Features

• add cursorSymbol to src/parsing/index.ts (d66d357)
• make debug parameter for parseGenericSql optional (631811b)

Bug Fixes

• fix genericAutocompleteParser.test.ts tests (0f8b51c)
• fix src/parsing/test/testing.ts type error (240b6c4)
• move parsers/test/testings.js to parsers/test/testing.ts (a803a58)
• remove aceRegex, parserFileRegex from babel, move root directories to src (4cde182)
• remove unnecessary files from babel.config.js, move it to babel.config.json, remove some deps (291bd96)
• update NOTICE.txt (1735cd1)