Pyprql

Breaking

* feat!: based on prql-python 0.8 (169) ([`0e4a62f`](https://github.com/PRQL/pyprql/commit/0e4a62f086c5abe39a426ecc20ea3285b23fe4b4))

Chore

* chore: allow pandas 2.0 and jupysql 0.7 (167)

I think it is not necessary to specify strict dependencies here. ([`6042b3f`](https://github.com/PRQL/pyprql/commit/6042b3fb910ae35307e97ed45aac893f79e6a725))

Feature

* feat: autopolars support (170)

A new feature of jupysql 0.7 ([`db3edf3`](https://github.com/PRQL/pyprql/commit/db3edf34b08fca5c7129b570de02441f6c4e2c83))

Unknown

* [pre-commit.ci] pre-commit autoupdate (168)

<!--pre-commit.ci start-->
updates:
- [github.com/charliermarsh/ruff-pre-commit: v0.0.260 →
v0.0.261](https://github.com/charliermarsh/ruff-pre-commit/compare/v0.0.260...v0.0.261)
- [github.com/pre-commit/mirrors-mypy: v1.1.1 →
v1.2.0](https://github.com/pre-commit/mirrors-mypy/compare/v1.1.1...v1.2.0)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`42bd50c`](https://github.com/PRQL/pyprql/commit/42bd50c74e83a6c83bb2bb3ec3b6633b0e14a9a8))

* [pre-commit.ci] pre-commit autoupdate (166)

<!--pre-commit.ci start-->
updates:
- [github.com/charliermarsh/ruff-pre-commit: v0.0.259 →
v0.0.260](https://github.com/charliermarsh/ruff-pre-commit/compare/v0.0.259...v0.0.260)
- [github.com/psf/black: 23.1.0 →
23.3.0](https://github.com/psf/black/compare/23.1.0...23.3.0)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`99316d0`](https://github.com/PRQL/pyprql/commit/99316d0301b3a7f20d2c621026427f3a6dad6021))

Breaking

* refactor!: remove deprecated cli module and update dependencies (162)

Remove the cli module, which has been deprecated since pyprql 0.5.10
(released on PyPI on 2022-12-12) (93), and update dependencies.

This PR also includes a configuration change for python-semantic-release
(`major_on_zero = false`), making the release after this disruptive
change `0.7.0` instead of `1.0.0`. ([`89e1199`](https://github.com/PRQL/pyprql/commit/89e11996a9f46ea6e16b07c8cba253f2d4e8341b))

Build

* build: Have ReadTheDocs pass (153) ([`e66b40c`](https://github.com/PRQL/pyprql/commit/e66b40c2d02636ba7facdccc4cc3ec0546eb8322))

* build: Move some dependencies to dev-dependencies (152) ([`9b6f2f5`](https://github.com/PRQL/pyprql/commit/9b6f2f58e9fd439495faca6523d2fc7a027e9058))

Chore

* chore: depends on prql-python 0.7 (163) ([`d6c82b5`](https://github.com/PRQL/pyprql/commit/d6c82b57e89d818f2e896b11162b95f5ec7186ad))

* chore: remove outdated PRQL example files (157) ([`7beeb01`](https://github.com/PRQL/pyprql/commit/7beeb01758ae97a066101279fabc944d761512b8))

Documentation

* docs: Add `compile` function (154)

And explain how this differs from `prql-python`. Closes 151. ([`917062e`](https://github.com/PRQL/pyprql/commit/917062e0850a96c6d7e9623abfb3f0a9c9397263))

Feature

* feat(magic): support PRQL query in line magic (160)

Supports execution of PRQL queries in line magic, like that.

python
results = %prql from p = `products.csv` | aggregate [min unitsInStock, max unitsInStock]


This PR also changes the function that performs argument parsing from
`sql.parse.magic_args` to
`IPython.core.magic_arguments.parse_argstring`.
In SQL we need to use `sql.parse.magic_args` because the comment
character is `--` in SQL. In PRQL, we do not need to consider `--`.
`IPython.core.magic_arguments.parse_argstring` is more strict and will
raise an error for unsupported arguments such as `--foo`.

default
In [1]: %load_ext pyprql.magic

In [2]: %prql --foo from a
UsageError: unrecognized arguments: --foo
([`0b0f8d8`](https://github.com/PRQL/pyprql/commit/0b0f8d87f780930d6dd8852cdcbb52353baed2da))

* feat(magic): add `dryrun` config option to only print SQL output (159)

`%config PrqlMagic.dryrun=True` allows to just printing without
executing output SQL.

---------

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`b5a602f`](https://github.com/PRQL/pyprql/commit/b5a602f2873c43666b6fed0d4423270c27e0f484))

Fix

* fix: fix python versions (165)

IPython is not supporting python 3.7 ([`fb70408`](https://github.com/PRQL/pyprql/commit/fb70408e183f4d94c103200362702f1274dd4c92))

* fix: fix GitHub Actions workflows and more python versions support (164)

I noticed that the checks by CI were not actually using the Python
version of the matrix, so I&39;m fixing that.

I&39;m also fixing other errors discovered using actionlint and remove
nonworking codecov step. ([`0901392`](https://github.com/PRQL/pyprql/commit/0901392fe4f698acb3db6d9b9fc9b039782643ae))

* fix(magic): support `.prql` file with the `--file` arg option (158) ([`98dfcab`](https://github.com/PRQL/pyprql/commit/98dfcabecef0db540c11e59fce8c2c7c667176ba))

Unknown

* [pre-commit.ci] pre-commit autoupdate (161)

<!--pre-commit.ci start-->
updates:
- [github.com/charliermarsh/ruff-pre-commit: v0.0.257 →
v0.0.259](https://github.com/charliermarsh/ruff-pre-commit/compare/v0.0.257...v0.0.259)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`f9b48de`](https://github.com/PRQL/pyprql/commit/f9b48de9ac7d927368a060f431158f16fe8fc636))

* [pre-commit.ci] pre-commit autoupdate (155)

<!--pre-commit.ci start-->
updates:
- [github.com/charliermarsh/ruff-pre-commit: v0.0.254 →
v0.0.257](https://github.com/charliermarsh/ruff-pre-commit/compare/v0.0.254...v0.0.257)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`52fcd23`](https://github.com/PRQL/pyprql/commit/52fcd2347c5fe2db69d9035d4bddb2c56e164d64))

* [pre-commit.ci] pre-commit autoupdate (149)

<!--pre-commit.ci start-->
updates:
- [github.com/pre-commit/mirrors-mypy: v1.0.1 →
v1.1.1](https://github.com/pre-commit/mirrors-mypy/compare/v1.0.1...v1.1.1)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`8f5cb50`](https://github.com/PRQL/pyprql/commit/8f5cb50554fac37685ba828c5e0159fc47d510cf))

Build

* build: bump prql-python to 0.6.0 (141) ([`0956908`](https://github.com/PRQL/pyprql/commit/09569084b3bf367a4a26de47d5bb363a04e82d96))

Chore

* chore: fix release workflow (146)

This reverts commit 3eb119c.

3eb119c failed to release build due to missing Poetry. ([`3c08f42`](https://github.com/PRQL/pyprql/commit/3c08f428b976dca95a5e40ff3f5ab3659e9635b8))

* chore: bump codecov/codecov-action from 2 to 3 (143)

Bumps
[codecov/codecov-action](https://github.com/codecov/codecov-action) from
2 to 3.
<details>
<summary>Release notes</summary>
<p><em>Sourced from <a
href=&34;https://github.com/codecov/codecov-action/releases">codecov/codecov-action&39;s
releases</a>.</em></p>
<blockquote>
<h2>v3.0.0</h2>
<h3>Breaking Changes</h3>
<ul>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/689">689</a>
Bump to node16 and small fixes</li>
</ul>
<h3>Features</h3>
<ul>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/688">688</a>
Incorporate <code>gcov</code> arguments for the Codecov uploader</li>
</ul>
<h3>Dependencies</h3>
<ul>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/548">548</a>
build(deps-dev): bump jest-junit from 12.2.0 to 13.0.0</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/603">603</a>
[Snyk] Upgrade <code>​actions/core</code> from 1.5.0 to 1.6.0</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/628">628</a>
build(deps): bump node-fetch from 2.6.1 to 3.1.1</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/634">634</a>
build(deps): bump node-fetch from 3.1.1 to 3.2.0</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/636">636</a>
build(deps): bump openpgp from 5.0.1 to 5.1.0</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/652">652</a>
build(deps-dev): bump <code>​vercel/ncc</code> from 0.30.0 to
0.33.3</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/653">653</a>
build(deps-dev): bump <code>​types/node</code> from 16.11.21 to
17.0.18</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/659">659</a>
build(deps-dev): bump <code>​types/jest</code> from 27.4.0 to
27.4.1</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/667">667</a>
build(deps): bump actions/checkout from 2 to 3</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/673">673</a>
build(deps): bump node-fetch from 3.2.0 to 3.2.3</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/683">683</a>
build(deps): bump minimist from 1.2.5 to 1.2.6</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/685">685</a>
build(deps): bump <code>​actions/github</code> from 5.0.0 to 5.0.1</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/681">681</a>
build(deps-dev): bump <code>​types/node</code> from 17.0.18 to
17.0.23</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/682">682</a>
build(deps-dev): bump typescript from 4.5.5 to 4.6.3</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/676">676</a>
build(deps): bump <code>​actions/exec</code> from 1.1.0 to 1.1.1</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/675">675</a>
build(deps): bump openpgp from 5.1.0 to 5.2.1</li>
</ul>
<h2>v2.1.0</h2>
<h2>2.1.0</h2>
<h3>Features</h3>
<ul>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/515">515</a>
Allow specifying version of Codecov uploader</li>
</ul>
<h3>Dependencies</h3>
<ul>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/499">499</a>
build(deps-dev): bump <code>​vercel/ncc</code> from 0.29.0 to
0.30.0</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/508">508</a>
build(deps): bump openpgp from 5.0.0-5 to 5.0.0</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/514">514</a>
build(deps-dev): bump <code>​types/node</code> from 16.6.0 to
16.9.0</li>
</ul>
<h2>v2.0.3</h2>
<h2>2.0.3</h2>
<h3>Fixes</h3>
<ul>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/464">464</a>
Fix wrong link in the readme</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/485">485</a>
fix: Add override OS and linux default to platform</li>
</ul>
<h3>Dependencies</h3>
<ul>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/447">447</a>
build(deps): bump openpgp from 5.0.0-4 to 5.0.0-5</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/458">458</a>
build(deps-dev): bump eslint from 7.31.0 to 7.32.0</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/465">465</a>
build(deps-dev): bump <code>​typescript-eslint/eslint-plugin</code>
from 4.28.4 to 4.29.1</li>
<li><a
href=&34;https://redirect.github.com/codecov/codecov-action/issues/466">466</a>
build(deps-dev): bump <code>​typescript-eslint/parser</code> from

Build

* build: Bump prql-python to 0.5.0 (134) ([`08f751d`](https://github.com/PRQL/pyprql/commit/08f751d63d98cac4421faa06865567ea27e0edde))

* build: Update dependencies (128) ([`499e8e7`](https://github.com/PRQL/pyprql/commit/499e8e723875ed4d29dd2202a16a31dd99ba6c6e))

* build: Upgrade dependencies (124) ([`619ab0b`](https://github.com/PRQL/pyprql/commit/619ab0b96f0403cf3a51cb777b336fb0b2fe0dc3))

* build: Consolidate onto ruff for linting (121) ([`3c7f498`](https://github.com/PRQL/pyprql/commit/3c7f49810c942f8bef5a007897e3c634fd704452))

Chore

* chore: Fix Changelog (115)

I&39;m really not sure what&39;s going on with semantic-release — I think it
might be time to move off it... ([`cfba1b1`](https://github.com/PRQL/pyprql/commit/cfba1b1a407ab770684fdcdd1a24db4914af16c3))

Ci

* ci: Try using a bare `pytest` in CI (131) ([`83c25a7`](https://github.com/PRQL/pyprql/commit/83c25a780e9527fa116d503e713fe95536f2b451))

* ci: Use PSR action (117)

If this doesn&39;t work, we&39;ll disable the auto-release... ([`04e1eeb`](https://github.com/PRQL/pyprql/commit/04e1eebf74ee804667539adf15b859953823711e))

* ci: Use prql-bot account to release (116) ([`10a9b73`](https://github.com/PRQL/pyprql/commit/10a9b732258c868ff57092340b2af24a25b5403f))

Documentation

* docs: Fix docs build (118) ([`c7e7365`](https://github.com/PRQL/pyprql/commit/c7e73656c27b7891dc61053b5cca4b64c299e555))

Feature

* feat: Upgrade to prql-python 0.4 (129)

Overhaul docs, including fixing 126 ([`ba5afa8`](https://github.com/PRQL/pyprql/commit/ba5afa80fb27b8d998c39789f110c4e1ce1904de))

Test

* test: Add ruff to pre-commit (120) ([`e9fe9e0`](https://github.com/PRQL/pyprql/commit/e9fe9e0bb1c8010006b5f6aa0926254ef0b4f75c))

Unknown

* [pre-commit.ci] pre-commit autoupdate (133)

<!--pre-commit.ci start-->
updates:
- [github.com/charliermarsh/ruff-pre-commit: v0.0.237 →
v0.0.241](https://github.com/charliermarsh/ruff-pre-commit/compare/v0.0.237...v0.0.241)
- [github.com/psf/black: 22.12.0 →
23.1.0](https://github.com/psf/black/compare/22.12.0...23.1.0)
<!--pre-commit.ci end-->

---------

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`6b561fe`](https://github.com/PRQL/pyprql/commit/6b561fed8f02b296ad8b961bbc1133d92034c425))

* [pre-commit.ci] pre-commit autoupdate (132) ([`fa457e3`](https://github.com/PRQL/pyprql/commit/fa457e326510373559d15dab9748b1cee5dd3f56))

* [pre-commit.ci] pre-commit autoupdate (130)

<!--pre-commit.ci start-->
updates:
- [github.com/charliermarsh/ruff-pre-commit: v0.0.223 →
v0.0.230](https://github.com/charliermarsh/ruff-pre-commit/compare/v0.0.223...v0.0.230)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com>
Co-authored-by: Maximilian Roos <5635139+max-sixtyusers.noreply.github.com> ([`2be0377`](https://github.com/PRQL/pyprql/commit/2be037732b57d9329734a6bb85c8d0158f3486b6))

* [pre-commit.ci] pre-commit autoupdate (127)

<!--pre-commit.ci start-->
updates:
- [github.com/charliermarsh/ruff-pre-commit: v0.0.215 →
v0.0.223](https://github.com/charliermarsh/ruff-pre-commit/compare/v0.0.215...v0.0.223)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`aa37bbb`](https://github.com/PRQL/pyprql/commit/aa37bbb4883f6995f1f3bec75d21b4a823bbf974))

* [pre-commit.ci] pre-commit autoupdate (123)

<!--pre-commit.ci start-->
updates:
- [github.com/charliermarsh/ruff-pre-commit: v0.0.206 →
v0.0.215](https://github.com/charliermarsh/ruff-pre-commit/compare/v0.0.206...v0.0.215)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com>
Co-authored-by: Maximilian Roos <5635139+max-sixtyusers.noreply.github.com> ([`8482784`](https://github.com/PRQL/pyprql/commit/84827840b2d74c550adb99bd2f89205141d226d1))

* [pre-commit.ci] pre-commit autoupdate (122)

<!--pre-commit.ci start-->
updates:
- [github.com/charliermarsh/ruff-pre-commit: v0.0.189 →
v0.0.206](https://github.com/charliermarsh/ruff-pre-commit/compare/v0.0.189...v0.0.206)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`283a0ec`](https://github.com/PRQL/pyprql/commit/283a0eca7b6eb0fa9f41a351fa6c5c789b372aec))

* tests: Add test suite to magic module (119)

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`893665c`](https://github.com/PRQL/pyprql/commit/893665c98dd27d0e8514017c1ddb9f606e29cbe6))

Build

* build: Bump version locally (114)

Me & semantic-release really aren&39;t getting along well... ([`6e5db20`](https://github.com/PRQL/pyprql/commit/6e5db20dd0b697a71a8bf1257bb7c7302141616d))

Documentation

* docs: Add a demo Colab Notebook (113)

Still need to provide links to it

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`d6fde68`](https://github.com/PRQL/pyprql/commit/d6fde683c2ac86217f5a95e2dee2c885de91ae88))

Unknown

* 0.5.12 (112)

I think a commit with just this title is required to get
semantic-release to work again

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`968cb22`](https://github.com/PRQL/pyprql/commit/968cb220fb2ad46d2d35c90d62b29b181e98edfe))

Build

* build: Transition to ploomber/jupysql (108)

Thanks a lot to catherinedevlin for kicking off the extension!

Because of https://github.com/catherinedevlin/ipython-sql/issues/210,
it&39;s necessary for us to transition to a fork, but open-minded on what
we depend on if things get merged upstream. ([`5042934`](https://github.com/PRQL/pyprql/commit/5042934e718342dc3550a65d9a3a3696d5533b0c))

Chore

* chore: Update version to 0.5.11 (111)

Not sure why semantic-release isn&39;t working, so doing manually ([`711c15b`](https://github.com/PRQL/pyprql/commit/711c15b66108b91fe6095e1d9e0c3962aa11eed3))

* chore: Add changelog for 0.5.10 (110)

Not sure whether this is the thing that&39;s preventing semantic-release
from working... ([`5451a62`](https://github.com/PRQL/pyprql/commit/5451a62633159eb567d0fa681b99078ec2ed9997))

Fix

* fix: Add py3.8-compatible typing (109)

This demonstrates we need tests for the magic...

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`cb3df80`](https://github.com/PRQL/pyprql/commit/cb3df80d33895f443aa50d5585675aa79a477550))

Unknown

* [pre-commit.ci] pre-commit autoupdate (107)

<!--pre-commit.ci start-->
updates:
- [github.com/PyCQA/isort: v5.11.3 →
5.11.4](https://github.com/PyCQA/isort/compare/v5.11.3...5.11.4)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`f4ea638`](https://github.com/PRQL/pyprql/commit/f4ea6389779ff6e37dd1560455412669b4eb6418))

* [pre-commit.ci] pre-commit autoupdate (106)

<!--pre-commit.ci start-->
updates:
- [github.com/PyCQA/isort: 5.10.1 →
v5.11.3](https://github.com/PyCQA/isort/compare/5.10.1...v5.11.3)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`1efec02`](https://github.com/PRQL/pyprql/commit/1efec02eef9838e597ffeec0a417cc0bd6bab331))

* [pre-commit.ci] pre-commit autoupdate (104)

<!--pre-commit.ci start-->
updates:
- [github.com/pre-commit/pre-commit-hooks: v4.1.0 →
v4.4.0](https://github.com/pre-commit/pre-commit-hooks/compare/v4.1.0...v4.4.0)
- [github.com/psf/black: 22.3.0 →
22.12.0](https://github.com/psf/black/compare/22.3.0...22.12.0)
- [github.com/pre-commit/mirrors-mypy: v0.982 →
v0.991](https://github.com/pre-commit/mirrors-mypy/compare/v0.982...v0.991)
- [github.com/PyCQA/flake8: 4.0.1 →
6.0.0](https://github.com/PyCQA/flake8/compare/4.0.1...6.0.0)
- [github.com/asottile/pyupgrade: v3.0.0 →
v3.3.1](https://github.com/asottile/pyupgrade/compare/v3.0.0...v3.3.1)
<!--pre-commit.ci end-->

Co-authored-by: pre-commit-ci[bot] <66853113+pre-commit-ci[bot]users.noreply.github.com> ([`1922f93`](https://github.com/PRQL/pyprql/commit/1922f931b4d269e30cb363b686fb4687d23d8144))