NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI · #771 most downloaded on PyPI
PostgREST client for Python. This library provides an ORM interface to PostgREST.
Last release today
02 Oct 2026
Release timing varies
gaps range from 8 days to 4 months
Nearly every release is documented
notes for 60 of the last 60 stable releases
1 version withdrawn
withdrawn after publishing
7 years old
71 releases · first in 2019
chore(release): bump version to v0.13.0 (`f7f786b`)
chore(release): bump version to v0.13.0 (f7f786b)
chore(deps-dev): bump black from 23.9.1 to 23.10.0 (#325)
Bumps black from 23.9.1 to 23.10.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (193c8df)
Co-authored-by: joel@joellee.org <joel@joellee.org> (7cd6751)
One column per quarter.
chore(release): bump version to v0.12.1 (`e2d2f0e`)
chore(release): bump version to v0.12.1 (e2d2f0e)
chore(deps-dev): bump pre-commit from 3.3.3 to 3.5.0 (#323)
Bumps pre-commit from 3.3.3 to 3.5.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (1209139)
chore: add python 3.12 to CI (#319)
chore: add python 3.12 to CI
chore: update autoflake hook
chore: add myself to codeowners
fix: make doc requirements optional (d1ee0bb)
04f4980)chore(release): bump version to v0.12.0 (`89b370f`)
89b370f)feat: add csv() modifier (#316)
fix: cast to correct type
feat: add csv() modifier
chore: export SingleRequestBuilder
chore: write tests for csv()
'Refactored by Sourcery' (#317)
Co-authored-by: Sourcery AI <>
Co-authored-by: sourcery-ai[bot] <58596630+sourcery-ai[bot]@users.noreply.github.com> (4f6e9d9)
chore(release): bump version to v0.11.0 (`5ae0f99`)
chore(release): bump version to v0.11.0 (5ae0f99)
chore(deps-dev): bump python-semantic-release from 7.34.6 to 8.1.1 (#311)
Bumps python-semantic-release from 7.34.6 to 8.1.1.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (d5a32d4)
Bumps pytest from 7.4.0 to 7.4.2.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (488721a)
Bumps black from 23.7.0 to 23.9.1.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (9e99b11)
Bumps furo from 2023.7.26 to 2023.9.10.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (39aa5c9)
Bumps sphinx from 7.0.1 to 7.1.2.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (c7a77a1)
Bumps gitpython from 3.1.34 to 3.1.35.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (324fa53)
Bumps gitpython from 3.1.32 to 3.1.34.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (ed6928a)
feat: generic query builders (#309)
feat: make all query builders generic
feat: return generic request builders from client methods
chore: use typing.List instead of builtin
chore: use typing.List
fix: correct type of APIResponse.data
feat: make RPCFilterRequestBuilder
This makes sure the return types of rpc() and other query methods are correct. See https://gist.github.com/anand2312/93d3abf401335fd3310d9e30112303bf for an explanation.
chore: use typing.List
feat: make get_origin_and_cast
This fixes the type-checker error raised while accessing RequestBuilder[T].origin
fix: use typing.List (ba9ad8d)
feat: update semver, add CODEOWNERS (#299)
Update ci.yml
chore: add CODEOWNERS
Co-authored-by: joel@joellee.org <joel@joellee.org> (18b5838)
fix: pre-commit hook to stop checks on md files (#315)
fix: pre-commit hook to stop checks on md files
fix(ci): using correct token to publish a release
fix: correct semantic release variable names (e8fbe61)
fix: update upsert type (#307)
Co-authored-by: joel@joellee.org <joel@joellee.org> (3329234)
fix: add semver (#297)
fix: add semver
fix: add environ and perms
Co-authored-by: joel@joellee.org <joel@joellee.org> (166fa7c)
a5efce6)8d1f249)fix: use new httpx parameter encoding in tests
chore: bump httpx to 0.24.1 (#277)
fix: use new httpx parameter encoding in tests
httpx changed how it formats query parameters in 0.24.0 - see here https://github.com/encode/httpx/blob/master/CHANGELOG.md#0240-6th-april-2023
chore: bump version
'Refactored by Sourcery' (#280)
Co-authored-by: Sourcery AI <>
Co-authored-by: joel@joellee.org <joel@joellee.org>
Co-authored-by: sourcery-ai[bot] <58596630+sourcery-ai[bot]@users.noreply.github.com> (561548e)
Co-authored-by: joel@joellee.org <joel@joellee.org> (`abb074f`)
Co-authored-by: joel@joellee.org <joel@joellee.org> (abb074f)
Bumps sphinx from 7.0.1 to 7.1.2.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (398610e)
Bumps strenum from 0.4.10 to 0.4.15.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (c20a7d9)
Bumps sphinx from 4.3.2 to 7.0.1.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (3bda953)
Bumps pydantic from 1.10.9 to 2.0.3.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (043cf2f)
Bumps pre-commit from 3.2.0 to 3.3.3.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (c56878f)
Bumps black from 23.1.0 to 23.3.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (3fde0fd)
Bumps sphinx from 4.3.2 to 7.0.1.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (7e18b17)
Bumps strenum from 0.4.9 to 0.4.10.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (1a8a2ad)
Bumps cryptography from 39.0.1 to 41.0.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (779d827)
Bumps pytest from 7.2.2 to 7.3.2.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (120786e)
Bumps furo from 2022.12.7 to 2023.5.20.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (ed7719c)
Bumps python-semantic-release from 7.33.2 to 7.34.6.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (f2931f9)
Bumps pydantic from 1.10.5 to 1.10.9.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (371c73d)
Bumps requests from 2.28.2 to 2.31.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (9153733)
Bumps pre-commit from 3.1.0 to 3.2.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (b319f64)
Bumps pytest from 7.2.1 to 7.2.2.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (67572ba)
feat: add py.typed (#258)
feat: add py.typed
fix: remove trailing line
Co-authored-by: joel@joellee.org <joel@joellee.org> (39ae07d)
Co-authored-by: joel@joellee.org <joel@joellee.org> (`167c401`)
Co-authored-by: joel@joellee.org <joel@joellee.org> (167c401)
Bumps pre-commit from 3.0.4 to 3.1.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (a98883e)
Bumps sphinx from 5.3.0 to 6.1.3.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (a2cdd3e)
Fix sanitize_params to correctly resolve nested columns (#222)
Add test for sanitize_params in utils
Remove dot character from sanitize_params util
Add tests for filter queries that include special characters in column name
Add missing test for equals operator (36a0702)
Co-authored-by: joel@joellee.org <joel@joellee.org> (`ea579fd`)
Co-authored-by: joel@joellee.org <joel@joellee.org> (ea579fd)
Bumps furo from 2022.9.29 to 2022.12.7.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (c1fb15f)
Bumps pydantic from 1.10.4 to 1.10.5.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (bb3318e)
Bumps sphinx from 4.3.2 to 5.3.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (6646131)
Bumps cryptography from 39.0.0 to 39.0.1.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (08c5cf7)
Bumps pre-commit from 2.21.0 to 3.0.4.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (da41692)
Bumps isort from 5.11.5 to 5.12.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (f10e569)
Bumps black from 22.12.0 to 23.1.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (261f8ce)
chore: update pre-commit (#209)
chore: update pre-commit
fix: convert to string
fix: drop py37
'Refactored by Sourcery' (#210)
Co-authored-by: Sourcery AI <>
Co-authored-by: joel@joellee.org <joel@joellee.org>
Co-authored-by: sourcery-ai[bot] <58596630+sourcery-ai[bot]@users.noreply.github.com> (4f451a3)
Co-authored-by: joel@joellee.org <joel@joellee.org> (0fa4e4e)
chore: bump ci poetry version (#186)
chore: bump poetry lock
fix: bump ci poetry version
Co-authored-by: joel@joellee.org <joel@joellee.org> (95db586)
Bumps isort from 5.10.1 to 5.11.4.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (4afd352)
Bumps wheel from 0.37.1 to 0.38.1.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (1448861)
Bumps certifi from 2022.9.24 to 2022.12.7.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (745be97)
Bumps httpx from 0.23.0 to 0.23.3.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (9d3a3d5)
feat: add text_search (#215)
feat: add text_search
fix: run pre-commit hooks
test: add tests for text search
fix: run black
fix: update poetry deps
Co-authored-by: joel@joellee.org <joel@joellee.org> (0d16b47)
feat: upsert with on-conflict support (#142)
feat: upsert with on-conflict support
fix: lint
Update postgrest/base_request_builder.py
Co-authored-by: Anand <40204976+anand2312@users.noreply.github.com>
chore: docs
chore: docs
Co-authored-by: Anand <40204976+anand2312@users.noreply.github.com> (ecc6e79)
feat: add support for 3.11 (#188)
fix: add StrEnum
fix: add 3.11 to ci
fix: run black and autoflake
Co-authored-by: joel@joellee.org <joel@joellee.org> (08f156a)
fix: handle Py311 Validation errors (#219)
fix: handle NoneType response
fix: add default error message for non JSONDecodable objects
fix: rename message -> details
fix: handle exception instead of checking for no content
Co-authored-by: joel@joellee.org <joel@joellee.org> (29cb042)
Co-authored-by: joel@joellee.org <joel@joellee.org> (228fe53)
Update README.md (7e87364)
Implementation of maybe_single (#118)
add initial implementation on maybe_single
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com>
Signed-off-by: Bariq <bariqhibat@gmail.com> (5d17f81)
Nothing published for this version
chore(deps-dev): bump flake8 from 4.0.1 to 5.0.4
Bumps flake8 from 4.0.1 to 5.0.4.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (28145b1)
Bumps pydantic from 1.9.1 to 1.10.2.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (8dec08f)
Bumps pytest from 7.1.2 to 7.1.3.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (56ddf21)
Bumps pytest-cov from 3.0.0 to 4.0.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (1e47d6d)
Bumps black from 22.3.0 to 22.10.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (7636691)
Bumps python-semantic-release from 7.28.1 to 7.32.1.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (4eb490a)
Bumps pre-commit from 2.19.0 to 2.20.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (6d948a7)
Bumps furo from 2022.6.4.1 to 2022.9.15.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (d1e50a2)
Bumps furo from 2022.4.7 to 2022.6.4.1.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (09142ab)
Bumps httpx from 0.22.0 to 0.23.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (0daf278)
Bumps pydantic from 1.9.0 to 1.9.1.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (e13a6e0)
Bumps pre-commit from 2.18.1 to 2.19.0.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (5c0c128)
Bumps pytest from 7.1.1 to 7.1.2.
updated-dependencies:
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> (36b7328)
Co-authored-by: joel@joellee.org <joel@joellee.org> (c1105dc)
limit and order on foreign tables (#120)
limit and order on foreign tables
Apply suggestions from code review
Co-authored-by: Anand <40204976+anand2312@users.noreply.github.com>
Updated docstrings for order and limit
Changed limit modifier to use limit param instead of range headers
Co-authored-by: privaterepo <hauntedanon420@gmail.com>
Co-authored-by: Anand <40204976+anand2312@users.noreply.github.com> (bf27b85)
Nothing published for this version
Your coding agent can read these notes before it upgrades. Set up the MCP server →