Jupysql

Latest version: v0.10.16

Safety actively analyzes 682251 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 6 of 12

0.7.0

JupySQL is now available via `conda install jupysql -c conda-forge`. Thanks, [sterlinm](https://github.com/sterlinm)!

* [API Change] Deprecates old SQL parametrization: `$var`, `:var`, and `{var}` in favor of `{{var}}`
* [Feature] Adds `%sqlcmd profile` ([66](https://github.com/ploomber/jupysql/issues/66))
* [Feature] Adds `%sqlcmd test` to run tests on tables
* [Feature] Adds `--interact` argument to `%%sql` to enable interactivity in parametrized SQL queries ([293](https://github.com/ploomber/jupysql/issues/293))
* [Feature] Results parse HTTP URLs to make them clickable ([230](https://github.com/ploomber/jupysql/issues/230))
* [Feature] Adds `ggplot` plotting API (histogram and boxplot)
* [Feature] Adds `%%config SqlMagic.polars_dataframe_kwargs = {...}` (by [jorisroovers](https://github.com/jorisroovers))
* [Feature] Adding `sqlglot` to better support SQL dialects in some internal SQL queries
* [Fix] Clearer error when using bad table/schema name with `%sqlcmd` and `%sqlplot` ([155](https://github.com/ploomber/jupysql/issues/155))
* [Fix] Fix `%sqlcmd` exception handling ([262](https://github.com/ploomber/jupysql/issues/262))
* [Fix] `--save` + `--with` double quotes syntax error in MySQL ([145](https://github.com/ploomber/jupysql/issues/145))
* [Fix] Clearer error when using `--with` with snippets that do not exist ([257](https://github.com/ploomber/jupysql/issues/257))
* [Fix] Pytds now automatically compatible
* [Fix] Jupysql with autopolars crashes when schema cannot be inferred from the first 100 rows (by [jorisroovers](https://github.com/jorisroovers)) ([#312](https://github.com/ploomber/jupysql/issues/312))
* [Fix] Fix problem where a `%name` in a query (even if commented) would be interpreted as a query parameter ([362](https://github.com/ploomber/jupysql/issues/362))
* [Fix] Better support for MySQL and MariaDB (generating internal SQL queries with backticks instead of double quotes)
* [Doc] Tutorial on ETLs via Jupysql and Github actions
* [Doc] SQL keywords autocompletion
* [Doc] Included schema and dataspec into `%sqlrender` API reference

0.6.6

* [Fix] Pinning SQLAlchemy 1.x

0.6.5

* [Feature] Displaying warning when passing a identifier with hyphens to `--save` or `--with`
* [Fix] Addresses enable AUTOCOMMIT config issue in PostgreSQL ([90](https://github.com/ploomber/jupysql/issues/90))
* [Doc] User guide on querying Github API with DuckDB and JupySQL

0.6.4

**Note:** This release has been yanked due to an error when using it with SQLAlchemy 2

* [Fix] Adds support for SQL Alchemy 2.0
* [Doc] Summary section on jupysql vs ipython-sql

0.6.3

* [Fix] Displaying variable substitution warning only when the variable to expand exists in the user's namespace

0.6.2

* [Fix] Deprecation warning incorrectly displayed [213](https://github.com/ploomber/jupysql/issues/213)

Page 6 of 12

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.