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

supabase / supabase-py / 43229511406
98%

Build:
DEFAULT BRANCH: main
Ran 12 Nov 2026 01:40PM UTC
Jobs 35
Files 139
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

12 Nov 2026 01:40PM UTC coverage: 97.743% (+0.03%) from 97.71%
43229511406

push

github

web-flow
feat(postgrest): add column expressions and the filter tree (#2041)

Step 1 of [SDK-2765](https://linear.app/supabase/issue/SDK-2765)
([SDK-2984](https://linear.app/supabase/issue/SDK-2984)): the typed
column expressions and the filter tree that the typed query builder, the
realtime bridge and the generator build on. A port of supabase-flutter
#1793 with the typed internals of SDK-1753.

## What

- `ColumnExpression[Row, Value]` with `Column`, `NullableColumn` and
`ComputedField`. `Row` and `Value` are invariant and default to `Any`
through `typing_extensions.TypeVar`, so `Column("deleted_at")` works
without generated code, while `Books.id.eq("seven")` and a filter from
another table are type errors under mypy, pyright and pyrefly without
plugins. `Column` and `NullableColumn` are siblings over a private base,
so a later `PartialRow.__getitem__` can overload on them without
overlapping.
- The comparison operators `eq`, `neq`, `gt`, `gte`, `lt`, `lte`,
`is_distinct`, `in_`, `text_search(query, type=, config=)` and
`raw(operand)`. `is_true()` and `is_false()` take an explicit `self:
ColumnExpression[Row, bool]`. `is_null()` exists on `NullableColumn` and
`ComputedField` only.
- `Filter[Row]`, composed with `&`, `|` and `~`, and `FilterOperator`
carrying the wire tokens. `Filter.comparison` exposes a leaf as
`Comparison(column, operator, value, negated)`, which is what the
realtime bridge will read. `Filter.raw(column, operand)` is the escape
hatch for an expression no column can name.
- Rendering happens when the request is built, by position: a top-level
`&` as separate query parameters, `|` as `or=(…)`, a nested `&` as
`and(…)`, a negated leaf in a group as `id.not.eq.2`, a negated group as
`not.and=(…)`, and a double negation collapsing. Operands go through the
string builder's `sanitize_param` and `_serialize_filter_value`, so the
output is the string builder's. `_serialize_filter_value` moves from
`request_builder.py` to `utils.py` next to `sanitiz... (continued)

14249 of 14578 relevant lines covered (97.74%)

5.05 hits per line

Coverage Regressions

Lines Coverage ∆ File
23
95.12
-0.09% src/postgrest/request_builder.py
1
97.56
0.59% src/postgrest/utils.py
Jobs
ID Job ID Ran Files Coverage
1 supabase-py3.14-highest - 43229511406.1 12 Nov 2026 01:40PM UTC 20
99.32
GitHub Action Run
2 utils-py3.14-highest - 43229511406.2 12 Nov 2026 01:41PM UTC 24
99.66
GitHub Action Run
3 storage-py3.15-highest - 43229511406.3 12 Nov 2026 01:43PM UTC 24
95.99
GitHub Action Run
4 supabase-py3.13-highest - 43229511406.4 12 Nov 2026 01:40PM UTC 20
99.32
GitHub Action Run
5 utils-py3.12-highest - 43229511406.5 12 Nov 2026 01:41PM UTC 24
99.67
GitHub Action Run
6 auth-py3.13-highest - 43229511406.6 12 Nov 2026 01:42PM UTC 43
96.77
GitHub Action Run
7 storage-py3.12-lowest-direct - 43229511406.7 12 Nov 2026 01:42PM UTC 24
95.99
GitHub Action Run
8 functions-py3.12-lowest-direct - 43229511406.8 12 Nov 2026 01:40PM UTC 14
99.12
GitHub Action Run
9 functions-py3.13-highest - 43229511406.9 12 Nov 2026 01:40PM UTC 14
99.12
GitHub Action Run
10 supabase-py3.12-highest - 43229511406.10 12 Nov 2026 01:40PM UTC 20
99.32
GitHub Action Run
11 utils-py3.15-highest - 43229511406.11 12 Nov 2026 01:41PM UTC 24
99.66
GitHub Action Run
12 supabase-py3.15-highest - 43229511406.12 12 Nov 2026 01:42PM UTC 20
99.32
GitHub Action Run
13 functions-py3.14-highest - 43229511406.13 12 Nov 2026 01:40PM UTC 14
99.12
GitHub Action Run
14 storage-py3.14-highest - 43229511406.14 12 Nov 2026 01:41PM UTC 24
95.99
GitHub Action Run
15 auth-py3.12-highest - 43229511406.15 12 Nov 2026 01:42PM UTC 43
96.77
GitHub Action Run
16 functions-py3.15-highest - 43229511406.16 12 Nov 2026 01:40PM UTC 14
99.12
GitHub Action Run
17 postgrest-py3.14-highest - 43229511406.17 12 Nov 2026 01:42PM UTC 34
98.46
GitHub Action Run
18 realtime-py3.14-highest - 43229511406.18 12 Nov 2026 01:41PM UTC 10
97.15
GitHub Action Run
19 auth-py3.12-lowest-direct - 43229511406.19 12 Nov 2026 01:42PM UTC 43
96.77
GitHub Action Run
20 storage-py3.12-highest - 43229511406.20 12 Nov 2026 01:42PM UTC 24
95.99
GitHub Action Run
21 postgrest-py3.13-highest - 43229511406.21 12 Nov 2026 01:42PM UTC 34
98.46
GitHub Action Run
22 functions-py3.12-highest - 43229511406.22 12 Nov 2026 01:40PM UTC 14
99.12
GitHub Action Run
23 postgrest-py3.12-lowest-direct - 43229511406.23 12 Nov 2026 01:42PM UTC 34
98.46
GitHub Action Run
24 realtime-py3.13-highest - 43229511406.24 12 Nov 2026 01:41PM UTC 10
97.51
GitHub Action Run
25 postgrest-py3.15-highest - 43229511406.25 12 Nov 2026 01:42PM UTC 34
98.46
GitHub Action Run
26 realtime-py3.15-highest - 43229511406.26 12 Nov 2026 01:41PM UTC 10
97.15
GitHub Action Run
27 auth-py3.15-highest - 43229511406.27 12 Nov 2026 01:42PM UTC 43
96.77
GitHub Action Run
28 auth-py3.14-highest - 43229511406.28 12 Nov 2026 01:42PM UTC 43
96.77
GitHub Action Run
29 utils-py3.13-highest - 43229511406.29 12 Nov 2026 01:41PM UTC 24
99.67
GitHub Action Run
30 postgrest-py3.12-highest - 43229511406.30 12 Nov 2026 01:42PM UTC 34
98.46
GitHub Action Run
31 realtime-py3.12-highest - 43229511406.31 12 Nov 2026 01:42PM UTC 10
97.39
GitHub Action Run
32 realtime-py3.12-lowest-direct - 43229511406.32 12 Nov 2026 01:42PM UTC 10
97.51
GitHub Action Run
33 storage-py3.13-highest - 43229511406.33 12 Nov 2026 01:42PM UTC 24
95.99
GitHub Action Run
34 utils-py3.12-lowest-direct - 43229511406.34 12 Nov 2026 01:41PM UTC 24
99.67
GitHub Action Run
35 supabase-py3.12-lowest-direct - 43229511406.35 12 Nov 2026 01:40PM UTC 20
99.32
GitHub Action Run
Source Files on build 43229511406
  • Tree
  • List 139
  • Changed 5
  • Source Changed 0
  • Coverage Changed 5
Coverage ∆ File Lines Relevant Covered Missed Hits/Line
  • Back to Repo
  • Github Actions Build #43229511406
  • 82e2bb33 on github
  • Prev Build on main (#43227923044)
  • Next Build on main (#43237516251)
  • 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