• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

supabase / supabase-py / 43845231689
99%

Build:
DEFAULT BRANCH: main
Ran 16 Nov 2026 10:02AM UTC
Jobs 35
Files 160
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

16 Nov 2026 10:02AM UTC coverage: 98.121% (+0.1%) from 98.013%
43845231689

push

github

web-flow
feat(postgrest): add the typed query builder (#2044)

Step 4 of [SDK-2765](https://linear.app/supabase/issue/SDK-2765)
([SDK-2987](https://linear.app/supabase/issue/SDK-2987)): the typed
query builder over the table definition, the request value and the
executors of #2043. A port of the typed builders of supabase-flutter
#1795, as they are today on top of `PostgrestTableRequest`.

```python
books = (
    client.table(Books.table)
    .select()
    .where((Books.pages.gt(300) | Books.isbn.is_null()) & ~Books.id.eq(1))
    .order(Books.title.desc().nulls_last())
    .limit(10)
    .execute()
)
# books: list[BooksRow]
```

## What

- `PostgrestClient.table(Books.table)` returns
`TypedQueryBuilder[Executor, Row, Insert, Update]` through an overload
on the type of the client: `TableExecutor` on `SyncPostgrestClient` and
`AsyncTableExecutor` on `AsyncPostgrestClient`, over the HTTP executor
of that client. `table("books")` keeps returning the string builder.
- The builders collect a `TableRequest` without rendering anything.
`execute()` hands it to the executor and converts the `TableResult`: it
returns `T` on the sync client and an awaitable of `T` on the async one,
through overloads on `self` as `handle_http_io` does, with the runtime
branch decided by what the executor returns. Every method returns a
copy.
- `TypedQueryBuilder`: `select()` resolves to `list[Row]` through a
cached `TypeAdapter(list[Row])`, `select_only([...])` to
`list[PartialRow[Row]]`; `insert`, `upsert(on_conflict=,
ignore_duplicates=)`, `update`, `delete` and `count()`.
- `TypedFilterBuilder.where(filter)`, combining repeated calls with `&`.
`TypedTransformBuilder`: `select`, `select_only`, `order` (appends),
`limit`, `range`, `strip_nulls`, `dry_run`, `max_affected`, `csv`
(`str`), `head` (`None`), `geojson` (`dict[str, JSON]`), `explain`
(`str`, or `JSON` with `format="json"`), `count` (`CountedResponse[T]`),
and `single` (`Row`) and `maybe_single` (`Row | None`), which an
explicit ... (continued)

17075 of 17402 relevant lines covered (98.12%)

5.05 hits per line

Coverage Regressions

Lines Coverage ∆ File
7
96.71
-0.42% src/postgrest/table_executor.py
Jobs
ID Job ID Ran Files Coverage
1 storage-py3.12-lowest-direct - 43845231689.1 16 Nov 2026 10:04AM UTC 24
95.99
GitHub Action Run
2 auth-py3.12-highest - 43845231689.2 16 Nov 2026 10:04AM UTC 43
96.77
GitHub Action Run
3 supabase-py3.14-highest - 43845231689.3 16 Nov 2026 10:03AM UTC 20
99.32
GitHub Action Run
4 utils-py3.15-highest - 43845231689.4 16 Nov 2026 10:03AM UTC 24
99.67
GitHub Action Run
5 realtime-py3.14-highest - 43845231689.5 16 Nov 2026 10:04AM UTC 10
97.3
GitHub Action Run
6 supabase-py3.12-lowest-direct - 43845231689.6 16 Nov 2026 10:03AM UTC 20
99.32
GitHub Action Run
7 auth-py3.15-highest - 43845231689.7 16 Nov 2026 10:04AM UTC 43
96.77
GitHub Action Run
8 realtime-py3.12-highest - 43845231689.8 16 Nov 2026 10:04AM UTC 10
97.63
GitHub Action Run
9 utils-py3.13-highest - 43845231689.9 16 Nov 2026 10:03AM UTC 24
99.67
GitHub Action Run
10 functions-py3.13-highest - 43845231689.10 16 Nov 2026 10:02AM UTC 14
99.12
GitHub Action Run
11 functions-py3.12-highest - 43845231689.11 16 Nov 2026 10:02AM UTC 14
99.12
GitHub Action Run
12 storage-py3.13-highest - 43845231689.12 16 Nov 2026 10:04AM UTC 24
95.99
GitHub Action Run
13 realtime-py3.13-highest - 43845231689.13 16 Nov 2026 10:04AM UTC 10
97.52
GitHub Action Run
14 functions-py3.15-highest - 43845231689.14 16 Nov 2026 10:03AM UTC 14
99.12
GitHub Action Run
15 storage-py3.14-highest - 43845231689.15 16 Nov 2026 10:04AM UTC 24
95.99
GitHub Action Run
16 supabase-py3.12-highest - 43845231689.16 16 Nov 2026 10:03AM UTC 20
99.32
GitHub Action Run
17 utils-py3.14-highest - 43845231689.17 16 Nov 2026 10:03AM UTC 24
99.67
GitHub Action Run
18 functions-py3.12-lowest-direct - 43845231689.18 16 Nov 2026 10:03AM UTC 14
99.12
GitHub Action Run
19 storage-py3.15-highest - 43845231689.19 16 Nov 2026 10:05AM UTC 24
95.99
GitHub Action Run
20 supabase-py3.15-highest - 43845231689.20 16 Nov 2026 10:04AM UTC 20
99.32
GitHub Action Run
21 supabase-py3.13-highest - 43845231689.21 16 Nov 2026 10:03AM UTC 20
99.32
GitHub Action Run
22 realtime-py3.12-lowest-direct - 43845231689.22 16 Nov 2026 10:04AM UTC 10
97.63
GitHub Action Run
23 auth-py3.13-highest - 43845231689.23 16 Nov 2026 10:04AM UTC 43
96.77
GitHub Action Run
24 functions-py3.14-highest - 43845231689.24 16 Nov 2026 10:03AM UTC 14
99.12
GitHub Action Run
25 utils-py3.12-highest - 43845231689.25 16 Nov 2026 10:03AM UTC 24
99.67
GitHub Action Run
26 utils-py3.12-lowest-direct - 43845231689.26 16 Nov 2026 10:03AM UTC 24
99.67
GitHub Action Run
27 storage-py3.12-highest - 43845231689.27 16 Nov 2026 10:04AM UTC 24
95.99
GitHub Action Run
28 realtime-py3.15-highest - 43845231689.28 16 Nov 2026 10:04AM UTC 10
97.42
GitHub Action Run
29 postgrest-py3.12-highest - 43845231689.29 16 Nov 2026 10:04AM UTC 56
99.19
GitHub Action Run
30 auth-py3.12-lowest-direct - 43845231689.30 16 Nov 2026 10:04AM UTC 43
96.77
GitHub Action Run
31 postgrest-py3.15-highest - 43845231689.31 16 Nov 2026 10:04AM UTC 56
99.19
GitHub Action Run
32 auth-py3.14-highest - 43845231689.32 16 Nov 2026 10:04AM UTC 43
96.77
GitHub Action Run
33 postgrest-py3.12-lowest-direct - 43845231689.33 16 Nov 2026 10:05AM UTC 56
99.19
GitHub Action Run
34 postgrest-py3.14-highest - 43845231689.34 16 Nov 2026 10:04AM UTC 56
99.19
GitHub Action Run
35 postgrest-py3.13-highest - 43845231689.35 16 Nov 2026 10:05AM UTC 56
99.19
GitHub Action Run
Source Files on build 43845231689
  • Tree
  • List 160
  • Changed 7
  • Source Changed 0
  • Coverage Changed 7
Coverage ∆ File Lines Relevant Covered Missed Hits/Line
  • Back to Repo
  • Github Actions Build #43845231689
  • e0ee463c on github
  • Prev Build on main (#43839950265)
  • Next Build on main (#43845298809)
  • Delete
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE TRIAL · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc