## 1.14.4 - 2025-01-31
### Bug Fixes
* Fix the usage instructions in the `\llm` command.
## 1.14.3 - 2025-01-29
### Bug Fixes
* Fix [misleading "0 rows affected" status for CTEs](https://github.com/dbcli/litecli/issues/203)
by never displaying rows affected when the connector tells us -1
* Show an error message when `\llm "question"` is invoked without a database connection.
## 1.14.2 - 2025-01-26
### Bug Fixes
* Catch errors surfaced by `llm` cli and surface them as runtime errors.
## 1.14.1 - 2025-01-25
### Bug Fixes
* Capture stderr in addition to stdout when capturing output from `llm` cli.
## 1.14.0 - 2025-01-22
### Features
* Add LLM feature to ask an LLM to create a SQL query.
- This adds a new `\llm` special command
- eg: `\llm "Who is the largest customer based on revenue?"`
### Bug Fixes
* Fix the [windows path](https://github.com/dbcli/litecli/issues/187) shown in prompt to remove escaping.
* Fix a bug where if column name was same as table name it was [crashing](https://github.com/dbcli/litecli/issues/155) the autocompletion.
### Internal
* Change min required python version to 3.9+
## 1.13.2 - 2024-11-24
### Internal
* Read the version from the git tag using setuptools-scm
## 1.13.0 - 2024-11-23
### Features
* Add `\pipe_once` / `\|` commands for sending output to a command
## 1.12.4 - 2024-11-11
### Bug Fixes
* Fix the syntax error when `\d tbl` is used.
## 1.12.3 - 2024-09-10
### Bug Fixes
* Specify build system in `pyproject.toml`
* Don't install tests
## 1.12.2 - 2024-09-07
### Bug Fixes
* Fix the missing packages due to invalid pyproject.toml config
## 1.12.1 - 2024-09-07 (Yanked)
### Internal Changes
* Modernize the project with following changes:
* pyproject.toml instead of setup.py
* Use ruff for linting and formatting
* Update GH actions to use uv and tox
* Use GH actions to release a new version
## 1.11.1 - 2024-07-04
### Bug Fixes
* Fix the escape sequence warning.
## 1.11.0 - 2024-05-03
### Improvements
* When an empty `\d` is invoked the list of tables are returned instead of an error.
* Show SQLite version at startup.
### Bug Fixes
* Support a single item in the startup commands in the config. (bug #176)
## 1.10.1 - 2024-3-23
### Bug Fixes
* Do not crash at start up if ~/.config/litecli is not writeable. [#172](https://github.com/dbcli/litecli/issues/172)
## 1.10.0 - 2022-11-19
### Features
* Adding support for startup commands being set in liteclirc and executed on startup. Limited to commands already implemented in litecli. ([[#56](https://github.com/dbcli/litecli/issues/56)])
### Bug Fixes
* Fix [[#146](https://github.com/dbcli/litecli/issues/146)], making sure `.once`
can be used more than once in a session.
* Fixed setting `successful = True` only when query is executed without exceptions so
failing queries get `successful = False` in `query_history`.
* Changed `master` to `main` in CONTRIBUTING.md to reflect GitHubs new default branch
naming.
* Fixed `.once -o <file>` by opening the output file once per statement instead
of for every line of output ([#148](https://github.com/dbcli/litecli/issues/148)).
* Use the sqlite3 API to cancel a running query on interrupt
([#164](https://github.com/dbcli/litecli/issues/164)).
* Skip internal indexes in the .schema output
([#170](https://github.com/dbcli/litecli/issues/170)).
## 1.9.0 - 2022-06-06
### Features
* Add support for ANSI escape sequences for coloring the prompt.
* Add support for `.indexes` command.
* Add an option to turn off the auto-completion menu. Completion menu can be
triggered by pressed the `<tab>` key when this option is set to False. Fixes
[#105](https://github.com/dbcli/litecli/issues/105).
### Bug Fixes
* Fix [#120](https://github.com/dbcli/litecli/issues/120). Make the `.read` command actually read and execute the commands from a file.
* Fix [#96](https://github.com/dbcli/litecli/issues/96) the crash in VI mode when pressing `r`.
## 1.8.0 - 2022-03-29
### Features
* Update compatible Python versions. (Thanks: [blazewicz])
* Add support for Python 3.10. (Thanks: [blazewicz])
* Drop support for Python 3.6. (Thanks: [blazewicz])
### Bug Fixes
* Upgrade cli_helpers to workaround Pygments regression.
* Use get_terminal_size from shutil instead of click.
## 1.7.0 - 2022-01-11
### Features
* Add config option show_bottom_toolbar.
### Bug Fixes
* Pin pygments version to prevent breaking change.
## 1.6.0 - 2021-03-15
### Features
* Add verbose feature to `favorite_query` command. (Thanks: [Zhaolong Zhu])
* `\f query` does not show the full SQL.
* `\f+ query` shows the full SQL.
* Add prompt format of file's basename. (Thanks: [elig0n])
### Bug Fixes
* Fix compatibility with sqlparse >= 0.4.0. (Thanks: [chocolateboy])
* Fix invalid utf-8 exception. (Thanks: [Amjith])
## 1.4.1 - 2020-07-27
### Bug Fixes
* Fix setup.py to set `long_description_content_type` as markdown.
## 1.4.0 - 2020-07-27
### Features
* Add NULLS FIRST and NULLS LAST to keywords. (Thanks: [Amjith])
## 1.3.2 - 2020-03-11
* Fix the completion engine to work with newer sqlparse.
## 1.3.1 - 2020-03-11
* Remove the version pinning of sqlparse package.
## 1.3.0 - 2020-02-11
### Features
* Added `.import` command for importing data from file into table. (Thanks: [Zhaolong Zhu])
* Upgraded to prompt-toolkit 3.x.
## 1.2.0 - 2019-10-26
### Features
* Enhance the `describe` command. (Thanks: [Amjith])
* Autocomplete table names for special commands. (Thanks: [Amjith])
## 1.1.0 - 2019-07-14
### Features
* Added `.read` command for reading scripts.
* Added `.load` command for loading extension libraries. (Thanks: [Zhiming Wang])
* Add support for using `?` as a placeholder in the favorite queries. (Thanks: [Amjith])
* Added shift-tab to select the previous entry in the completion menu. [Amjith]
* Added `describe` and `desc` keywords.
### Bug Fixes
* Clear error message when directory does not exist. (Thanks: [Irina Truong])
## 1.0.0 - 2019-01-04
* To new beginnings. :tada:
[Amjith]: https://blog.amjith.com
[chocolateboy]: https://github.com/chocolateboy
[Irina Truong]: https://github.com/j-bennet
[Zhaolong Zhu]: https://github.com/zzl0
[Zhiming Wang]: https://github.com/zmwangx