SeaQL/sea-query

View on GitHub

🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite

Stars: 1.8k
Forks: 275
Open beginner issues: 0
Indexed issues: 64
Avg merge: 1h 5m
Merged PRs (30d): 1

Dominant language: Rust
License: No license data
Last GitHub push: Sep 16, 2026
Latest indexed: Sep 19, 2026
Contributing guide: Contributing guide
Code of conduct: Code of conduct
Beginner labels: help wanted good first issue

Beginner friendly Everything

Open All

64 open issues indexed

(PG) `using()` combined with `not_null()` emits invalid SQL — USING placed after SET NOT NULL Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

SeaQL/sea-query#1099 · 1 comment · Opened Aug 15, 2026
Make sea-query-sqlx return a `SqlSafeStr` Open

Difficulty 3/5 1-2 days Newbie friendliness 58/100

SeaQL/sea-query#1089 · Opened Aug 1, 2026
Experiment with deleting `ConditionHolder(Contents)` Open

breaking-change-2.0

Difficulty 5/5 Over a week Newbie friendliness 35/100

SeaQL/sea-query#1079 · Opened May 31, 2026
PostgreSQL `cust_with_values` fails on ARRAY[...] literals (placeholder swallowing) Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

SeaQL/sea-query#1073 · 2 comments · Opened May 15, 2026
Add "alter table constraint" support separately from table definition Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

SeaQL/sea-query#1053 · Opened Feb 5, 2026
Support `JOIN ... USING` Open

help wanted

Difficulty 3/5 1-2 days Newbie friendliness 48/100

SeaQL/sea-query#1046 · Opened Jan 25, 2026
Support rusqlite array Open

help wanted

Difficulty 4/5 3-5 days Newbie friendliness 45/100

SeaQL/sea-query#1041 · Opened Jan 11, 2026
Add a wrapper for `serde_json::Value` Open

help wanted Perf

Difficulty 4/5 3-5 days Newbie friendliness 48/100

SeaQL/sea-query#1032 · 4 comments · Opened Dec 24, 2025
Validate whether the syntax is compatible with the specific backend Open

Difficulty 5/5 Over a week Newbie friendliness 15/100

SeaQL/sea-query#1031 · Opened Dec 24, 2025
Support More SQL Open

help wanted

Difficulty 4/5 3-5 days Newbie friendliness 35/100

SeaQL/sea-query#1022 · Opened Dec 16, 2025
Add aggregate functions to `ExprTrait` Open

C-enhancement help wanted

Difficulty 3/5 1-2 days Newbie friendliness 45/100

SeaQL/sea-query#989 · Opened Sep 11, 2025
Postgres binder type hints Open

Difficulty 5/5 Over a week Newbie friendliness 15/100

SeaQL/sea-query#986 · Opened Aug 31, 2025
Json functions Open

C-enhancement help wanted

Difficulty 5/5 Over a week Newbie friendliness 15/100

SeaQL/sea-query#985 · Opened Aug 31, 2025
Redesign `TypeName`, `DynIden` and `Expr` for correctness Open

breaking-change-2.0

Difficulty 5/5 Over a week Newbie friendliness 25/100

SeaQL/sea-query#954 · 19 comments · Opened Aug 13, 2025
Other operators for sub-queries (gte, eq, in, ...) Open

C-enhancement help wanted

Difficulty 4/5 3-5 days Newbie friendliness 35/100

SeaQL/sea-query#951 · Opened Aug 7, 2025
Create COMPOSITE types (Postgres) Open

C-enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

SeaQL/sea-query#950 · Opened Aug 7, 2025
Support PostgreSQL 'point' type Open

C-enhancement

Difficulty 3/5 1-2 days Newbie friendliness 45/100

SeaQL/sea-query#911 · 1 reaction · Opened Jul 17, 2025
Support for specifying operator class in expression indexes (e.g. gist_trgm_ops) Open

C-enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

SeaQL/sea-query#907 · 1 reaction · Opened Jul 10, 2025
Enable using DISTINCT with any Function Open

C-enhancement

Difficulty 2/5 1-3 hours Newbie friendliness 55/100

SeaQL/sea-query#901 · Opened Jul 4, 2025
Union does not put the first query in parenthesis Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

SeaQL/sea-query#879 · 2 comments · 1 reaction · Opened Apr 11, 2025
Support for index hints Open

C-enhancement help wanted

Difficulty 5/5 Over a week Newbie friendliness 25/100

SeaQL/sea-query#871 · 3 comments · Opened Mar 30, 2025
Custom Functions keyword arguments Open

C-enhancement help wanted

Difficulty 4/5 3-5 days Newbie friendliness 42/100

SeaQL/sea-query#870 · Opened Mar 27, 2025
Support Postgres Interval type Open

C-enhancement

Difficulty 3/5 1-2 days Newbie friendliness 35/100

SeaQL/sea-query#855 · 1 comment · 3 reactions · Opened Jan 2, 2025
`RETURNING` support for MariaDB Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

SeaQL/sea-query#847 · 1 comment · Opened Dec 15, 2024
No way to express "excluded" in upsert where clause in SeaQL Open

C-enhancement

Difficulty 3/5 1-2 days Newbie friendliness 45/100

SeaQL/sea-query#842 · 1 comment · 1 reaction · Opened Nov 24, 2024
`sea-query-binder` links to `sqlite3` conflict Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

SeaQL/sea-query#823 · 2 comments · Opened Oct 4, 2024
[BUG] Enum_def macro errror Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

SeaQL/sea-query#793 · 2 comments · Opened Jul 13, 2024
Exposition of Postgres functions `to_tsquery`, `to_tsvector`, `phraseto_tsquery`, `plainto_tsquery`, `websearch_to_tsquery` are unergonomic because they only accept the regconfig as an u32 Open

C-enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

SeaQL/sea-query#784 · 3 comments · 1 reaction · Opened Jun 13, 2024
fails to build Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

SeaQL/sea-query#781 · 3 comments · Opened Jun 1, 2024
Parentheses for complex LIKE query is different than the same Postgres ILIKE query Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

SeaQL/sea-query#776 · 1 comment · Opened May 2, 2024
Support for Postgres comments when creating tables and columns Open

C-enhancement

Difficulty 4/5 3-5 days Newbie friendliness 42/100

SeaQL/sea-query#761 · 1 comment · Opened Mar 20, 2024
Error running sqlx_any in example after upgrading sqlx to 0.7 Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

SeaQL/sea-query#752 · 1 comment · Opened Feb 7, 2024
Add support for `Arc<str>` value Open

C-enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

SeaQL/sea-query#738 · 2 comments · Opened Jan 12, 2024
`Table::drop()` with multiple `.table` when using sqlite3 causes invalid sql Open

Sqlite Validation

Difficulty 2/5 1-3 hours Newbie friendliness 48/100

SeaQL/sea-query#737 · 2 comments · 1 reaction · Opened Jan 8, 2024
postgres: silently uses signed integers when unsigned integers are specified in schema Open

C-enhancement

Difficulty 4/5 3-5 days Newbie friendliness 38/100

SeaQL/sea-query#731 · 2 comments · Opened Jan 4, 2024
postgres: bulk insert API with UNNEST and ARRAYs Open

C-enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

SeaQL/sea-query#724 · 5 comments · 1 reaction · Opened Dec 17, 2023
postgres: Support creating partitioned tables Open

C-enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

SeaQL/sea-query#722 · 2 comments · 5 reactions · Opened Dec 1, 2023
Macro for generating the Iden from a given Struct Open

C-enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

SeaQL/sea-query#717 · 6 comments · 2 reactions · Opened Oct 23, 2023
Supporting a new type in SeaQuery Open

C-enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

SeaQL/sea-query#714 · 1 comment · Opened Oct 11, 2023
Multiple arguments / multiple parameters on custom postgres function breaking with Func::cust().args() Open

needs-info

Difficulty 4/5 3-5 days Newbie friendliness 20/100

SeaQL/sea-query#699 · 1 comment · Opened Sep 10, 2023
Do typechecking on postgres value binder (implement `accepts`) Open

binder

Difficulty 3/5 1-2 days Newbie friendliness 45/100

SeaQL/sea-query#696 · 1 comment · Opened Sep 7, 2023
Explicitly annotate values in postgres when types cannot be inferred Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

SeaQL/sea-query#695 · 4 comments · Opened Sep 7, 2023
Array type not annotated when array type cannot be inferred in postgres Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

SeaQL/sea-query#693 · 1 comment · 1 reaction · Opened Sep 5, 2023
Support postgres Array constructor as function Open

C-enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

SeaQL/sea-query#683 · Opened Aug 23, 2023
Iden all columns Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

SeaQL/sea-query#654 · 3 comments · 1 reaction · Opened Jul 10, 2023
Add support for `get_json_field` and `cast_json_field` for all backends Open

C-enhancement

Difficulty 3/5 1-2 days Newbie friendliness 45/100

SeaQL/sea-query#631 · 1 comment · 1 reaction · Opened Apr 9, 2023
Support delete with join `DELETE alias FROM tbl alias JOIN other_tbl ...` Open

C-enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

SeaQL/sea-query#627 · 1 comment · 2 reactions · Opened Mar 31, 2023
Add support for key length in MySQL Open

C-enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

SeaQL/sea-query#621 · Opened Mar 18, 2023
Add support for PostgreSQL's geometric point type Open

C-enhancement

Difficulty 3/5 1-2 days Newbie friendliness 35/100

SeaQL/sea-query#615 · 1 comment · Opened Mar 6, 2023
Support `JOIN`s in `UpdateStatement` (`join_subquery`, `inner_join`, etc.) Open

C-enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

SeaQL/sea-query#608 · 10 comments · 1 reaction · Opened Feb 21, 2023

SeaQL/sea-query

Get new issues in your inbox