crates.io · #1582 most downloaded on crates.io

sea-query

1.0.236M downloads/moSeaQL/sea-query ↗New releases in your daily digest, changelog included.

🔱 A dynamic query builder for MySQL, Postgres and SQLite

Last release 1 months ago
12 Aug 2026
Release timing varies
gaps range from 8 days to 3 months
Nearly every release is documented
notes for 60 of the last 60 stable releases
10 versions withdrawn
withdrawn after publishing
6 years old
165 releases · first in 2020

Release timeline

165 releases since 2020

2020202120222023202420252026

20202026

One column per quarter.

Releases

0.30.41 Dec 20233 sources agree
Impl QueryStatementWriter as inherent methods for WithQuery
Enhancements

Impl QueryStatementWriter as inherent methods for WithQuery
Open source →
0.30.322 Nov 20233 sources agree
Added LTree column type https://github.com/SeaQL/sea-query/pull/604
New Features

Added LTree column type https://github.com/SeaQL/sea-query/pull/604

Improved parenthesis omission logic https://github.com/SeaQL/sea-query/pull/675

Bug Fixes

Fixed BIGINT PRIMARY KEY AUTOINCREMENT for SQLite https://github.com/SeaQL/sea-query/issues/689

Upgrades

Upgrade chrono to 0.4.27

Breaking changes

Removed ToTokens for PgInterval https://github.com/SeaQL/sea-query/pull/710

sea-query-derive 0.4.1 - 2023-10-19

Upgrade syn to 2
Open source →

0.30.224 Sept 20233 sources agree

Fixed incorrect behavior when adding an autoincrement column for Postgres https://github.com/SeaQL/sea-query/pull/697

sea-query-diesel/0.1.0

Bug Fixes

Fixed incorrect behavior when adding an autoincrement column for Postgres https://github.com/SeaQL/sea-query/pull/697

Enhancements

Make ValueTuple hashable

Open source →

0.30.125 Aug 20233 sources agree

Added Func::round and Func::round_with_precision https://github.com/SeaQL/sea-query/pull/671

Versions

New Features

Added Func::round and Func::round_with_precision https://github.com/SeaQL/sea-query/pull/671

Enhancements

Added some getters to FunctionCall https://github.com/SeaQL/sea-query/pull/677

Bug Fixes

Fixed bytea literal syntax for Postgres https://github.com/SeaQL/sea-query/pull/666
Fixed issues with semantics of parenthesis removal https://github.com/SeaQL/sea-query/pull/675
Fixed behaviour in FunctionCall when calling arg multiple times https://github.com/SeaQL/sea-query/pull/687

Breaking changes

As part of https://github.com/SeaQL/sea-query/pull/687, calling FunctionCall::arg multiple times will append the arguments instead of replacing old values

Open source →

0.30.020 Jul 2023Breaking3 sources agree

sea-query 0.29 has a number of breaking changes, so it might be easier for you to first upgrade to 0.29, then upgrade sqlx by bumping to 0.30.

This is a small (but major) upgrade, the only changes are:

Upgrade SQLx to 0.7 https://github.com/SeaQL/sea-query/pull/652
Upgrade ipnetwork to 0.20

Versions

sea-query-binder/0.5.0

Notes

sea-query 0.29 has a number of breaking changes, so it might be easier for you to first upgrade to 0.29, then upgrade sqlx by bumping to 0.30.

Open source →

0.29.112 Jul 2023Deprecated3 sources agree

Deprecated Expr::asteriks and Expr::table_asteriks https://github.com/SeaQL/sea-query/pull/596

Versions

sea-query/0.29.0-rc.1: 2023-03-22
sea-query/0.29.0 (Yanked)
sea-query/0.29.1: 2023-07-12
sea-query-binder/0.4.0
sea-query-postgres/0.3.0
sea-query-rusqlite/0.3.0

New Features

Added ValueTuple::Many for tuple with length up to 12 https://github.com/SeaQL/sea-query/pull/564
Added CREATE TABLE CHECK constraints https://github.com/SeaQL/sea-query/pull/567
Added support generated column spec https://github.com/SeaQL/sea-query/pull/581
Added BIT_AND, BIT_OR functions https://github.com/SeaQL/sea-query/pull/582
Added implementation SqlxBinder, RusqliteBinder and PostgresBinder for WithQuery https://github.com/SeaQL/sea-query/pull/580
Added new type Asteriks https://github.com/SeaQL/sea-query/pull/596
Added IF NOT EXISTS for DROP INDEX in Postgres and Sqlite https://github.com/SeaQL/sea-query/pull/610
Added -> and ->> operators for Postgres https://github.com/SeaQL/sea-query/pull/617
Added TableCreateStatement::set_extra and TableCreateStatement::get_extra https://github.com/SeaQL/sea-query/pull/611
Added TableCreateStatement::comment and ColumnDef::comment for MySQL comments https://github.com/SeaQL/sea-query/pull/622
Added PgExpr::get_json_field and PgExpr::cast_json_field methods for constructing Postgres JSON expressions https://github.com/SeaQL/sea-query/pull/630
Added PgBinOper::Regex and PgBinOper::RegexCaseInsensitive for Postgres Regex operators
Added BinOper::Custom for defining custom binary operators
Added GLOB operator for Sqlite https://github.com/SeaQL/sea-query/pull/651/
Added CREATE or DROP EXTENSION statements for Postgres https://github.com/SeaQL/sea-query/pull/616
Added a feature flag hashable-value, which will impl Hash for Value; when enabled, Value::Float(NaN) == Value::Float(NaN) would be true https://github.com/SeaQL/sea-query/pull/598
Added PgBinOper::Overlap for Postgres operators https://github.com/SeaQL/sea-query/pull/653

Enhancements

Implemented PartialEq for DynIden, SimpleExpr and related types https://github.com/SeaQL/sea-query/pull/620

Breaking changes

Removed variants Four, Five, Six from enum ValueTuple as part of https://github.com/SeaQL/sea-query/pull/564
Removed Expr::tbl, Expr::greater_than, Expr::greater_or_equal, Expr::less_than, Expr::less_or_equal, Expr::into_simple_expr https://github.com/SeaQL/sea-query/pull/551
Removed SimpleExpr::equals and SimpleExpr::not_equals https://github.com/SeaQL/sea-query/pull/551
Removed InsertStatement::exprs, InsertStatement::exprs_panic https://github.com/SeaQL/sea-query/pull/551
Removed OnConflict::update_value, OnConflict::update_values, OnConflict::update_expr, OnConflict::update_exprs https://github.com/SeaQL/sea-query/pull/551
Removed UpdateStatement::exprs, UpdateStatement::col_expr, UpdateStatement::value_expr https://github.com/SeaQL/sea-query/pull/551
BigInteger now maps to bigint instead of integer on SQLite https://github.com/SeaQL/sea-query/pull/556
Table::truncate now panic for Sqlite https://github.com/SeaQL/sea-query/pull/590
Deprecated Expr::asteriks and Expr::table_asteriks https://github.com/SeaQL/sea-query/pull/596
Expr::cust, Expr::cust_with_values, Expr::cust_with_expr, Expr::cust_with_exprs, TableForeignKey::name, ForeignKeyCreateStatement::name, ForeignKeyDropStatement::name, TableIndex::name, IndexCreateStatement::name, IndexDropStatement::name, SqlWriterValues::new, ColumnType::custom, TableCreateStatement::engine, TableCreateStatement::collate, TableCreateStatement::character_set, TableRef::new, LikeExpr::str now accept T: Into<String> https://github.com/SeaQL/sea-query/pull/594
OnConflict::values and OnConflict::update_columns will append the new values keeping the old values intact instead of erasing them https://github.com/SeaQL/sea-query/pull/609
As part of https://github.com/SeaQL/sea-query/pull/620, SeaRc now becomes a wrapper type. If you used SeaRc for something other than dyn Iden, you now have to use RcOrArc. However be reminded that it is not an intended use of the API anyway.

// new definition
struct SeaRc<I>(RcOrArc<I>);
// remains unchanged
type DynIden = SeaRc<dyn Iden>;

// if you did:
let _: DynIden = Rc::new(Alias::new("char"));
// replace with:
let _: DynIden = SeaRc::new(Alias::new("char"));

Added new type Quote and changed the Iden trait:

struct Quote(pub(crate) u8, pub(crate) u8);

trait Iden {
    // then:
    fn prepare(&self, s: &mut dyn fmt::Write, q: char);
    // now:
    fn prepare(&self, s: &mut dyn fmt::Write, q: Quote);

    // then:
    fn quoted(&self, q: char) -> String;
    // now:
    fn quoted(&self, q: Quote) -> String;
}

House keeping

Elided unnecessary lifetimes https://github.com/SeaQL/sea-query/pull/552
Changed all version = "^x.y.z" into version = "x.y.z" in all Cargo.toml https://github.com/SeaQL/sea-query/pull/547/
Disabled default features and enable only the needed ones https://github.com/SeaQL/sea-query/pull/547/
tests_cfg module is available only if you enabled tests-cfg feature https://github.com/SeaQL/sea-query/pull/584
Removed hard coded quotes https://github.com/SeaQL/sea-query/pull/613
Enabled required syn v1 features https://github.com/SeaQL/sea-query/pull/624
Fix macro hygiene (any! / all!) https://github.com/SeaQL/sea-query/pull/639 https://github.com/SeaQL/sea-query/pull/640

Bug fixes

ALTER TABLE now panic if has multiple column for Sqlite https://github.com/SeaQL/sea-query/pull/595
Fixed alter primary key column statements for Postgres https://github.com/SeaQL/sea-query/pull/646

Open source →

0.29.012 Jul 2023withdrawn

Nothing published for this version

0.29.0-rc.215 May 2023pre-release

Nothing published for this version

0.29.0-rc.122 Mar 2023pre-release

Nothing published for this version

0.28.511 May 20233 sources agree

Added implementation SqlxBinder, RusqliteBinder and PostgresBinder for WithQuery https://github.com/SeaQL/sea-query/pull/580

Added implementation SqlxBinder, RusqliteBinder and PostgresBinder for WithQuery https://github.com/SeaQL/sea-query/pull/580
- sea-query-binder 0.3.1
- sea-query-postgres 0.2.1
- sea-query-rusqlite 0.2.1

Open source →

0.28.411 Apr 20233 sources agree

Fix quoted string bug while inserting array of strings to Postgres https://github.com/SeaQL/sea-query/pull/576

Bug fixes

Fix quoted string bug while inserting array of strings to Postgres https://github.com/SeaQL/sea-query/pull/576
Added comma if multiple names are passed to TypeDropStatement https://github.com/SeaQL/sea-query/pull/623

Open source →

0.28.318 Jan 20233 sources agree

Added getter for the UpdateStatement::values field https://github.com/SeaQL/sea-query/pull/578

Enhancements

Added getter for the UpdateStatement::values field https://github.com/SeaQL/sea-query/pull/578
Implements PartialEq for ColumnType https://github.com/SeaQL/sea-query/pull/579
Added helper function to construct ColumnType::Custom https://github.com/SeaQL/sea-query/pull/579

Open source →

0.28.24 Jan 20233 sources agree

Added Cow conversion to Value https://github.com/SeaQL/sea-query/pull/550

Enhancements

Added Cow<str> conversion to Value https://github.com/SeaQL/sea-query/pull/550
Added convert various UUID defined in uuid::fmt module into sea_query::Value::Uuid https://github.com/SeaQL/sea-query/pull/563

Open source →

0.28.129 Dec 20223 sources agree

Fixes Postgres GEN_RANDOM_UUID https://github.com/SeaQL/sea-query/issues/568

Bug fixes

Fixes Postgres GEN_RANDOM_UUID https://github.com/SeaQL/sea-query/issues/568

Open source →

0.28.09 Dec 2022Deprecated3 sources agree

Deprecated Expr::greater_than, Expr::greater_or_equal, Expr::less_than and Expr::less_or_equal https://github.com/SeaQL/sea-query/pull/476

New Features

New struct FunctionCall which hold function and arguments https://github.com/SeaQL/sea-query/pull/475
New trait IdenStatic with method fn as_str(&self) -> &'static str https://github.com/SeaQL/sea-query/pull/508
New traits PgExpr and SqliteExpr for custom expressions https://github.com/SeaQL/sea-query/pull/519
Support BigDecimal, IpNetwork and MacAddress for sea-query-postgres https://github.com/SeaQL/sea-query/pull/503

API Additions

Added SelectStatement::from_function https://github.com/SeaQL/sea-query/pull/475
Added binary operators from the Postgres pg_trgm extension https://github.com/SeaQL/sea-query/pull/486
Added ILIKE and NOT ILIKE operators https://github.com/SeaQL/sea-query/pull/473
Added the mul and div methods for SimpleExpr https://github.com/SeaQL/sea-query/pull/510
Added the MATCH, -> and ->> operators for SQLite https://github.com/SeaQL/sea-query/pull/513
Added the FULL OUTER JOIN https://github.com/SeaQL/sea-query/pull/497
Added PgFunc::get_random_uuid https://github.com/SeaQL/sea-query/pull/530
Added SimpleExpr::eq, SimpleExpr::ne, Expr::not_equals https://github.com/SeaQL/sea-query/pull/528
Added PgFunc::starts_with https://github.com/SeaQL/sea-query/pull/529
Added Expr::custom_keyword and SimpleExpr::not https://github.com/SeaQL/sea-query/pull/535
Added SimpleExpr::like, SimpleExpr::not_like and Expr::cast_as https://github.com/SeaQL/sea-query/pull/539
Added support for NULLS NOT DISTINCT clause for Postgres https://github.com/SeaQL/sea-query/pull/532
Added Expr::cust_with_expr and Expr::cust_with_exprs https://github.com/SeaQL/sea-query/pull/531
Added support for converting &String to Value https://github.com/SeaQL/sea-query/issues/537

Enhancements

Made value::with_array module public and therefore making NotU8 trait public https://github.com/SeaQL/sea-query/pull/511
Drop the Sized requirement on implementers of SchemaBuilders https://github.com/SeaQL/sea-query/pull/524

Bug fixes

Wrap unions into parenthesis https://github.com/SeaQL/sea-query/pull/498
Syntax error on empty condition https://github.com/SeaQL/sea-query/pull/505


// given
let (statement, values) = sea_query::Query::select()
    .column(Glyph::Id)
    .from(Glyph::Table)
    .cond_where(Cond::any()
        .add(Cond::all()) // empty all() => TRUE
        .add(Cond::any()) // empty any() => FALSE
    )
    .build(sea_query::MysqlQueryBuilder);

// old behavior
assert_eq!(statement, r#"SELECT `id` FROM `glyph`"#);

// new behavior
assert_eq!(
    statement,
    r#"SELECT `id` FROM `glyph` WHERE (TRUE) OR (FALSE)"#
);

Breaking changes

MSRV is up to 1.62 https://github.com/SeaQL/sea-query/pull/535
ColumnType::Array definition changed from Array(SeaRc<Box<ColumnType>>) to Array(SeaRc<ColumnType>) https://github.com/SeaQL/sea-query/pull/492
Func::* now returns FunctionCall instead of SimpleExpr https://github.com/SeaQL/sea-query/pull/475
Func::coalesce now accepts IntoIterator<Item = SimpleExpr> instead of IntoIterator<Item = Into<SimpleExpr> https://github.com/SeaQL/sea-query/pull/475
Removed Expr::arg and Expr::args - these functions are no longer needed https://github.com/SeaQL/sea-query/pull/475
Moved all Postgres specific operators to PgBinOper https://github.com/SeaQL/sea-query/pull/507
Expr::value, Expr::gt, Expr::gte, Expr::lt, Expr::lte, Expr::add, Expr::div, Expr::sub, Expr::modulo, Expr::left_shift, Expr::right_shift, Expr::between, Expr::not_between, Expr::is, Expr::is_not, Expr::if_null now accepts Into<SimpleExpr> instead of Into<Value> https://github.com/SeaQL/sea-query/pull/476
Expr::is_in, Expr::is_not_in now accepts Into<SimpleExpr> instead of Into<Value> and convert it to SimpleExpr::Tuple instead of SimpleExpr::Values https://github.com/SeaQL/sea-query/pull/476
Expr::expr now accepts Into<SimpleExpr> instead of SimpleExpr https://github.com/SeaQL/sea-query/pull/475
Moved Expr::ilike, Expr::not_ilike, Expr::matches, Expr::contains, Expr::contained, Expr::concatenate, Expr::concat, SimpleExpr::concatenate and SimpleExpr::concat to new trait PgExpr https://github.com/SeaQL/sea-query/pull/519
Expr::equals now accepts C: IntoColumnRef instead of T: IntoIden, C: IntoIden https://github.com/SeaQL/sea-query/pull/528
Removed integer and date time column types' display length / precision option https://github.com/SeaQL/sea-query/pull/525

Deprecations

Deprecated Expr::greater_than, Expr::greater_or_equal, Expr::less_than and Expr::less_or_equal https://github.com/SeaQL/sea-query/pull/476
Deprecated SimpleExpr::equals, SimpleExpr::not_equals https://github.com/SeaQL/sea-query/pull/528
Deprecated Expr::tbl, please use Expr::col with a tuple https://github.com/SeaQL/sea-query/pull/540

House keeping

Replace impl Default with #[derive(Default)] https://github.com/SeaQL/sea-query/pull/535
Exclude sqlx default features https://github.com/SeaQL/sea-query/pull/543
Use dtolnay/rust-toolchain instead of actions-rs/toolchain in CI https://github.com/SeaQL/sea-query/pull/544

Open source →

0.27.214 Nov 20223 sources agree

Made value::with_array module public and therefore making NotU8 trait public https://github.com/SeaQL/sea-query/pull/511

Made value::with_array module public and therefore making NotU8 trait public https://github.com/SeaQL/sea-query/pull/511

Open source →

0.27.118 Oct 20223 sources agree

Fix consecutive spacing on schema statements https://github.com/SeaQL/sea-query/pull/481

Fix consecutive spacing on schema statements https://github.com/SeaQL/sea-query/pull/481
SQLite bind rust_decimal & bigdecimal as f64 https://github.com/SeaQL/sea-query/pull/480

Open source →

0.27.016 Oct 2022Deprecated3 sources agree

Removed deprecated methods (or_where, or_having, table_column etc) https://github.com/SeaQL/sea-query/pull/380

New Features

Support CROSS JOIN https://github.com/SeaQL/sea-query/pull/376
We are going through series of changes to how database drivers work (https://github.com/SeaQL/sea-query/pull/416, https://github.com/SeaQL/sea-query/pull/423):
1. sea-query-binder is now the recommended way (trait based) of working with SQLx, replacing sea-query-driver (macro based) https://github.com/SeaQL/sea-query/pull/434
2. sea-query-binder is now a separate dependency, instead of integrated with sea-query https://github.com/SeaQL/sea-query/pull/432
3. rusqlite support is moved to sea-query-rusqlite https://github.com/SeaQL/sea-query/pull/422
4. postgres support is moved to sea-query-postgres https://github.com/SeaQL/sea-query/pull/433
Added sub-query operators: EXISTS, ALL, ANY, SOME https://github.com/SeaQL/sea-query/pull/379
Added support to ON CONFLICT WHERE https://github.com/SeaQL/sea-query/pull/447
Added support DROP COLUMN for SQLite https://github.com/SeaQL/sea-query/pull/455
Added YEAR, BIT and VARBIT types https://github.com/SeaQL/sea-query/pull/466
Added support one dimension Postgres array for SQLx https://github.com/SeaQL/sea-query/pull/467

Enhancements

Handle Postgres schema name for schema statements https://github.com/SeaQL/sea-query/pull/385
Added %, << and >> binary operators https://github.com/SeaQL/sea-query/pull/419
Added RAND function https://github.com/SeaQL/sea-query/pull/430
Implements Display for Value https://github.com/SeaQL/sea-query/pull/425
Added INTERSECT and EXCEPT to UnionType https://github.com/SeaQL/sea-query/pull/438
Added OnConflict::value and OnConflict::values https://github.com/SeaQL/sea-query/issues/451
ColumnDef::default now accepts both Value and SimpleExpr https://github.com/SeaQL/sea-query/pull/436
OrderedStatement::order_by_customs, OrderedStatement::order_by_columns, OverStatement::partition_by_customs, OverStatement::partition_by_columns now accepts IntoIterator<Item = T> instead of Vec<T> https://github.com/SeaQL/sea-query/pull/448
Expr::case, CaseStatement::case and CaseStatement::finally now accepts Into<SimpleExpr> instead of Into<Expr> https://github.com/SeaQL/sea-query/pull/460
UpdateStatement::value now accept Into<SimpleExpr> instead of Into<Value> https://github.com/SeaQL/sea-query/pull/460
TableAlterStatement::rename_column, TableAlterStatement::drop_column, ColumnDef::new, ColumnDef::new_with_type now accepts IntoIden instead of Iden https://github.com/SeaQL/sea-query/pull/472

Bug Fixes

distinct_on properly handles ColumnRef https://github.com/SeaQL/sea-query/pull/450
Removed ON for DROP INDEX for SQLite https://github.com/SeaQL/sea-query/pull/462
Change datetime string format to include microseconds https://github.com/SeaQL/sea-query/pull/468
ALTER TABLE for PosgreSQL with UNIQUE constraint https://github.com/SeaQL/sea-query/pull/472

Breaking changes

Changed in_tuples interface to accept IntoValueTuple https://github.com/SeaQL/sea-query/pull/386
Removed deprecated methods (or_where, or_having, table_column etc) https://github.com/SeaQL/sea-query/pull/380
Changed cond_where chaining semantics https://github.com/SeaQL/sea-query/pull/417

// Before: will extend current Condition
assert_eq!(
    Query::select()
        .cond_where(any![Expr::col(Glyph::Id).eq(1), Expr::col(Glyph::Id).eq(2)])
        .cond_where(Expr::col(Glyph::Id).eq(3))
        .to_owned()
        .to_string(PostgresQueryBuilder),
    r#"SELECT WHERE "id" = 1 OR "id" = 2 OR "id" = 3"#
);
// Before: confusing, since it depends on the order of invocation:
assert_eq!(
    Query::select()
        .cond_where(Expr::col(Glyph::Id).eq(3))
        .cond_where(any![Expr::col(Glyph::Id).eq(1), Expr::col(Glyph::Id).eq(2)])
        .to_owned()
        .to_string(PostgresQueryBuilder),
    r#"SELECT WHERE "id" = 3 AND ("id" = 1 OR "id" = 2)"#
);
// Now: will always conjoin with `AND`
assert_eq!(
    Query::select()
        .cond_where(Expr::col(Glyph::Id).eq(1))
        .cond_where(any![Expr::col(Glyph::Id).eq(2), Expr::col(Glyph::Id).eq(3)])
        .to_owned()
        .to_string(PostgresQueryBuilder),
    r#"SELECT WHERE "id" = 1 AND ("id" = 2 OR "id" = 3)"#
);
// Now: so they are now equivalent
assert_eq!(
    Query::select()
        .cond_where(any![Expr::col(Glyph::Id).eq(2), Expr::col(Glyph::Id).eq(3)])
        .cond_where(Expr::col(Glyph::Id).eq(1))
        .to_owned()
        .to_string(PostgresQueryBuilder),
    r#"SELECT WHERE ("id" = 2 OR "id" = 3) AND "id" = 1"#
);

CURRENT_TIMESTAMP changed from being a function to keyword https://github.com/SeaQL/sea-query/pull/441
Update SQLite boolean type from integer to boolean https://github.com/SeaQL/sea-query/pull/400
Changed type of ColumnType::Enum from (String, Vec<String>) to: https://github.com/SeaQL/sea-query/pull/435

Enum {
    name: DynIden,
    variants: Vec<DynIden>,
}

Deprecated InsertStatement::exprs, InsertStatement::exprs_panic, OnConflict::update_value, OnConflict::update_values, OnConflict::update_expr, OnConflict::update_exprs, UpdateStatement::col_expr, UpdateStatement::value_expr, UpdateStatement::exprs https://github.com/SeaQL/sea-query/pull/460
InsertStatement::values, UpdateStatement::values now accepts IntoIterator<Item = SimpleExpr> instead of IntoIterator<Item = Value> https://github.com/SeaQL/sea-query/pull/460
Use native api from SQLx for SQLite to work with time https://github.com/SeaQL/sea-query/pull/412

House keeping

Cleanup IndexBuilder trait methods https://github.com/SeaQL/sea-query/pull/426
Introduce SqlWriter trait https://github.com/SeaQL/sea-query/pull/436
Remove unneeded vec! from examples https://github.com/SeaQL/sea-query/pull/448

Upgrades

Upgrade sqlx driver to 0.6.1

Open source →

0.26.413 Oct 20223 sources agree

Added support DROP COLUMN for SQLite https://github.com/SeaQL/sea-query/pull/455

New Features

Added support DROP COLUMN for SQLite https://github.com/SeaQL/sea-query/pull/455

Bug Fixes

Removed ON for DROP INDEX for SQLite https://github.com/SeaQL/sea-query/pull/462
Changed datetime display format to include microseconds https://github.com/SeaQL/sea-query/pull/468

Open source →

0.26.317 Aug 20223 sources agree

DROP NOT NULL for Postgres ALTER COLUMN https://github.com/SeaQL/sea-query/pull/394

Bug Fixes

DROP NOT NULL for Postgres ALTER COLUMN https://github.com/SeaQL/sea-query/pull/394

House keeping

Exclude chrono default-features https://github.com/SeaQL/sea-query/pull/410
Fix clippy warnings https://github.com/SeaQL/sea-query/pull/415

Open source →

0.26.221 Jul 20223 sources agree

Rename postgres-* features to with-* on postgres driver https://github.com/SeaQL/sea-query/pull/377

Bug Fixes

Rename postgres-* features to with-* on postgres driver https://github.com/SeaQL/sea-query/pull/377

Open source →

0.26.121 Jul 2022withdrawn

Nothing published for this version

0.26.01 Jul 20223 sources agree

Add support for VALUES lists https://github.com/SeaQL/sea-query/pull/351

New Features

Add support for VALUES lists https://github.com/SeaQL/sea-query/pull/351
Introduce sea-query-binder https://github.com/SeaQL/sea-query/pull/275
Convert from IpNetwork and MacAddress to Value https://github.com/SeaQL/sea-query/pull/364

Enhancements

Move escape and unescape string to backend https://github.com/SeaQL/sea-query/pull/306
LIKE ESCAPE support https://github.com/SeaQL/sea-query/pull/352 #353)
clear_order_by for OrderedStatement
Add method to make a column nullable https://github.com/SeaQL/sea-query/pull/365
Add is & is_not to Expr https://github.com/SeaQL/sea-query/pull/348
Add CURRENT_TIMESTAMP function https://github.com/SeaQL/sea-query/pull/349
Add in_tuples method to Expr https://github.com/SeaQL/sea-query/pull/345

Upgrades

Upgrade uuid to 1.0
Upgrade time to 0.3
Upgrade ipnetwork to 0.19
Upgrade bigdecimal to 0.3
Upgrade sqlx driver to 0.6

Breaking changes

As part of #306, the standalone functions escape_string and unescape_string are removed, and becomes backend specific. So now, you have to:

use sea_query::EscapeBuilder;

let string: String = MySqlQueryBuilder.escape_string(r#" "abc" "#);
let string: String = MysqlQueryBuilder.unescape_string(r#" \"abc\" "#);

Replace Value::Ipv4Network and Value::Ipv6Network to Value::IpNetwork https://github.com/SeaQL/sea-query/pull/364
Remove some redundant feature flags postgres-chrono, postgres-json, postgres-uuid, postgres-time. Use the with-* equivalence

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.25.0...0.26.0

Open source →

0.25.21 Jul 20223 sources agree

Introduce sea-query-binder https://github.com/SeaQL/sea-query/pull/275

New features

Introduce sea-query-binder https://github.com/SeaQL/sea-query/pull/275

Enhancements

Add method to make a column nullable https://github.com/SeaQL/sea-query/pull/365
Add is & is_not to Expr https://github.com/SeaQL/sea-query/pull/348
Add CURRENT_TIMESTAMP function https://github.com/SeaQL/sea-query/pull/349

Open source →

0.25.126 Jun 20223 sources agree

clear_order_by for OrderedStatement

Enhancements

clear_order_by for OrderedStatement

Open source →

0.25.028 May 20223 sources agree

CASE WHEN statement support https://github.com/SeaQL/sea-query/pull/304

New Features

CASE WHEN statement support https://github.com/SeaQL/sea-query/pull/304
Add support for Ip(4,6)Network and MacAddress https://github.com/SeaQL/sea-query/pull/309
[sea-query-attr] macro for deriving Iden enum from struct https://github.com/SeaQL/sea-query/pull/300
Add ability to alter foreign keys https://github.com/SeaQL/sea-query/pull/299
Select DISTINCT ON https://github.com/SeaQL/sea-query/pull/313

Enhancements

Insert Default https://github.com/SeaQL/sea-query/pull/266
Make sea-query-driver an optional dependency https://github.com/SeaQL/sea-query/pull/324
Add ABS function https://github.com/SeaQL/sea-query/pull/334
Support IF NOT EXISTS when create index https://github.com/SeaQL/sea-query/pull/332
Support different blob types in MySQL https://github.com/SeaQL/sea-query/pull/314
Add VarBinary column type https://github.com/SeaQL/sea-query/pull/331
Returning expression supporting SimpleExpr https://github.com/SeaQL/sea-query/pull/335

Bug fixes

Fix arguments when nesting custom expressions https://github.com/SeaQL/sea-query/pull/333
Fix clippy warnings for manual map https://github.com/SeaQL/sea-query/pull/337

Breaking Changes

Introducing a dedicated ReturningClause instead of reusing Select on returning: https://github.com/SeaQL/sea-query/pull/317

.returning(Query::select().column(Glyph::Id).take()) // before
.returning(Query::returning().columns([Glyph::Id])) // now

In #333, the custom expression API changed for Postgres, users should change their placeholder from ? to Postgres's $N

let query = Query::select()
    .columns([Char::Character, Char::SizeW, Char::SizeH])
    .from(Char::Table)
    .and_where(Expr::col(Char::Id).eq(1))
    .and_where(Expr::cust_with_values("6 = $2 * $1", vec![3, 2]).into())
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE "id" = 1 AND 6 = 2 * 3"#
);

As a side effect, ?? is no longer needed for escaping ?

let query = Query::select()
    .expr(Expr::cust_with_values(
        "data @? ($1::JSONPATH)",
        vec!["hello"],
    ))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT data @? ('hello'::JSONPATH)"#
);

In #314, ColumnType's Binary(Option<u32>) changed to Binary(BlobSize), so if you used Binary(None) before, you should change to Binary(BlobSize::Blob(None))

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.24.0...0.25.0

Open source →

0.24.611 May 20223 sources agree

Make sea-query-driver an optional dependency https://github.com/SeaQL/sea-query/pull/324

Make sea-query-driver an optional dependency https://github.com/SeaQL/sea-query/pull/324

Open source →

0.24.59 May 20223 sources agree

Insert or_default_values https://github.com/SeaQL/sea-query/pull/266

Insert or_default_values https://github.com/SeaQL/sea-query/pull/266

Open source →

0.24.426 Apr 20223 sources agree

* update sea-query-driver

update sea-query-driver

Open source →

0.24.326 Apr 20223 sources agree

Fix MySQL index create statement https://github.com/SeaQL/sea-query/pull/308

Bug fixes

Fix MySQL index create statement https://github.com/SeaQL/sea-query/pull/308

Enhancements

Add length check on condition array https://github.com/SeaQL/sea-query/pull/307

Open source →

0.24.218 Apr 20223 sources agree

Fixed https://github.com/SeaQL/sea-query/issues/303 driver breakage in 0.24.0

Bug fixes

Fixed https://github.com/SeaQL/sea-query/issues/303 driver breakage in 0.24.0

Notes: 0.24.0 & 0.24.1 were yanked

Open source →

0.24.115 Apr 2022withdrawn3 sources agree

CTE optional columns https://github.com/SeaQL/sea-query/pull/301

Enhancements

#295 Add parameter for SQLx path to proc-macro https://github.com/SeaQL/sea-query/pull/297

Bug fixes

CTE optional columns https://github.com/SeaQL/sea-query/pull/301

Open source →

0.24.05 Apr 2022withdrawn3 sources agree

Add LOWER and UPPER func https://github.com/SeaQL/sea-query/pull/276

New Features

Add LOWER and UPPER func https://github.com/SeaQL/sea-query/pull/276
Insert ON CONFLICT support https://github.com/SeaQL/sea-query/pull/279
#174 Add support for WINDOWS statement https://github.com/SeaQL/sea-query/pull/271
#142 full support lock in select https://github.com/SeaQL/sea-query/pull/289
#269 add support for postgres ANY, SOME, ALL https://github.com/SeaQL/sea-query/pull/283

Enhancements

Add support for multiple ALTER operations https://github.com/SeaQL/sea-query/pull/277
#229 add column if not exists https://github.com/SeaQL/sea-query/pull/278
#255 Add support to CommonTableExpression columns method https://github.com/SeaQL/sea-query/pull/284
#280 Rewrite drivers using proc-macro https://github.com/SeaQL/sea-query/pull/292

Bug fixes

#285 Fix timestamp_with_time_zone_len https://github.com/SeaQL/sea-query/pull/286

Breaking changes

The enum variants for LockType were renamed: Exclusive -> Update and Shared -> Share
As part of #283, the drivers are split to the sea-query-driver crate
1. Remove methods Value::is_json and Value::as_ref_json when feature: with-json is disabled
2. Remove methods Value::is_time_* and Value::as_ref_time_* when feature: with-time is disabled
3. Remove methods Value::is_chrono_* and Value::as_ref_chrono* when feature: with-chrono is disabled
4. Remove methods Value::is_decimal, Value::as_ref_decimal and Value::decimal_to_f64 when feature: with-rust_decimal is disabled
5. Remove methods Value::is_big_decimal, Value::as_ref_big_decimal and Value::big_decimal_to_f64 when feature: with-bigdecimal is disabled
6. Remove methods Value::is_uuid and Value::as_ref_uuid when feature: with-uuid is disabled
7. Remove methods Value::is_array and Value::as_ref_array when feature: postgres-array is disabled

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.23.0...0.24.0

Open source →

0.23.015 Mar 20223 sources agree

Supports time in addition to chrono https://github.com/SeaQL/sea-query/pull/267

New Features

Supports time in addition to chrono https://github.com/SeaQL/sea-query/pull/267

Enhancements

Allow for trailing commas in any and all macros https://github.com/SeaQL/sea-query/pull/270

Bug fixes

Fix UNIQUE table index expression syntax for sqlite https://github.com/SeaQL/sea-query/pull/227

Breaking changes

In order to co-exist with the time crate, Date, Time, DateTime etc are renamed to ChronoDate, ChronoTime, ChronoDateTime. In addition, new variants TimeDate, TimeTime, TimeDateTime and so on are introduced to Value.

Open source →

0.22.026 Feb 20223 sources agree

Support multiple tables in the select from by @Sytten in https://github.com/SeaQL/sea-query/pull/261

New Features

Support multiple tables in the select from by @Sytten in https://github.com/SeaQL/sea-query/pull/261
Add support for replace insert by @Sytten in https://github.com/SeaQL/sea-query/pull/262
Add ColumnType unsigned integer types by @billy1624 in https://github.com/SeaQL/sea-query/pull/211

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.21.0...0.22.0

Open source →

0.21.26 Feb 2022withdrawn

Nothing published for this version

0.21.16 Feb 2022withdrawn

Nothing published for this version

0.21.01 Feb 20223 sources agree

Use double quotes for quoting identifiers for SQLite by @SpyrosRoum in https://github.com/SeaQL/sea-query/pull/221

Breaking Changes

Use double quotes for quoting identifiers for SQLite by @SpyrosRoum in https://github.com/SeaQL/sea-query/pull/221

New Features

Implement RETURNING for SQLite by @SpyrosRoum in https://github.com/SeaQL/sea-query/pull/194
Support 'NULLS LAST' and 'NULLS FIRST' by @qyihua in https://github.com/SeaQL/sea-query/pull/210
[join-lateral] by @rex-remind101 in https://github.com/SeaQL/sea-query/pull/224
Insert from select by @05storm26 in https://github.com/SeaQL/sea-query/pull/238
Add Expr::asterisk() and Expr::tbl_asterisk(table: DynIden) methods - Fix #217 by @RomainMazB in https://github.com/SeaQL/sea-query/pull/219

Enhancements

Implement ToTokens for IntervalField by @autarch in https://github.com/SeaQL/sea-query/pull/195
Implemented 'Array' type for Postgres. by @kev0960 in https://github.com/SeaQL/sea-query/pull/205
Add Value::DateTimeLocal by @billy1624 in https://github.com/SeaQL/sea-query/pull/249
Add ColumnRef::SchemaTableColumn by @billy1624 in https://github.com/SeaQL/sea-query/pull/206
Datetime utc by @tyt2y3 in https://github.com/SeaQL/sea-query/pull/241
Support the use of chrono::DateTime<Utc> using the type alias DateTim… by @charleschege in https://github.com/SeaQL/sea-query/pull/222

Bug Fixes

Fix Postgres ColumnType::TinyInteger mapping by @billy1624 in https://github.com/SeaQL/sea-query/pull/207
PR without clippy warmings in file changed tab by @billy1624 in https://github.com/SeaQL/sea-query/pull/212

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.20.0...0.21.0

Open source →

0.20.011 Dec 20213 sources agree

Add TableRef::DatabaseSchemaTable by @billy1624 in https://github.com/SeaQL/sea-query/pull/193

Merged PRs

Add TableRef::DatabaseSchemaTable by @billy1624 in https://github.com/SeaQL/sea-query/pull/193

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.19.4...0.20.0

Open source →

0.19.411 Dec 20213 sources agree

Binding DateTime for SQLx MySQL & SQLite by @billy1624 in https://github.com/SeaQL/sea-query/pull/197

Merged PRs

Binding DateTime<FixedOffset> for SQLx MySQL & SQLite by @billy1624 in https://github.com/SeaQL/sea-query/pull/197

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.19.2...0.19.4

Open source →

0.19.311 Dec 2021withdrawn

Nothing published for this version

0.19.24 Dec 20213 sources agree

Impl ValueTuple Up to Six by @billy1624 in https://github.com/SeaQL/sea-query/pull/200

Merged PRs

Impl ValueTuple Up to Six by @billy1624 in https://github.com/SeaQL/sea-query/pull/200
Basic Benchmark by @tyt2y3 in https://github.com/SeaQL/sea-query/pull/192

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.19.1...0.19.2

Open source →

0.19.125 Nov 20213 sources agree

driver/postgres handle non-exhaustive Value by @billy1624 in https://github.com/SeaQL/sea-query/pull/191

Merged PRs

driver/postgres handle non-exhaustive Value by @billy1624 in https://github.com/SeaQL/sea-query/pull/191

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.19.0...0.19.1

Open source →

0.19.019 Nov 20213 sources agree

TableCreateStatement and TableDropStatement takes any IntoTableRef table name. by @josh-codes in https://github.com/SeaQL/sea-query/pull/186

Merged PRs

TableCreateStatement and TableDropStatement takes any IntoTableRef table name. by @josh-codes in https://github.com/SeaQL/sea-query/pull/186
Add ColumnType::Enum by @billy1624 in https://github.com/SeaQL/sea-query/pull/188
Update to Rust Edition 2021 by @billy1624 in https://github.com/SeaQL/sea-query/pull/189

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.18.2...0.19.0

Open source →

0.18.24 Nov 20213 sources agree

Rename "where" keywords in SelectStatement to suppress IDEA warnings by @baoyachi in https://github.com/SeaQL/sea-query/pull/166

Merged PRs

Rename "where" keywords in SelectStatement to suppress IDEA warnings by @baoyachi in https://github.com/SeaQL/sea-query/pull/166
Add binary method to expr by @Progdrasil in https://github.com/SeaQL/sea-query/pull/173
Cast expression as custom type by @billy1624 in https://github.com/SeaQL/sea-query/pull/170
Support tuple expression by @shuoli84 in https://github.com/SeaQL/sea-query/pull/178

Full Changelog: https://github.com/SeaQL/sea-query/compare/0.18.1...0.18.2

Open source →

0.18.126 Oct 20213 sources agree

[[#169]] Add support for Postgres interval type

[#169] Add support for Postgres interval type
[#171] Fix bug in Condition::add where Condition negation is ignored

Open source →

0.18.015 Oct 20213 sources agree

[[#159]] Add ValueType::column_type

[#159] Add ValueType::column_type
[#160] Add FromValueTuple trait

Open source →

0.17.326 Oct 20213 sources agree

[[#171]] Fix bug in Condition::add where Condition negation is ignored

[#171] Fix bug in Condition::add where Condition negation is ignored

Open source →

0.17.215 Oct 20213 sources agree

[[#164]] Revert "Fix SQLite chrono::NaiveTime binding"

[#164] Revert "Fix SQLite chrono::NaiveTime binding"

Open source →

0.17.112 Oct 2021withdrawn

Nothing published for this version

0.17.06 Oct 20213 sources agree

[[#157]] Fix binding nullable custom types on db drivers

[#157] Fix binding nullable custom types on db drivers

The as_ref_* methods on Value are changed:

pub fn as_ref_json(&self) -> &Json;

Is now

pub fn as_ref_json(&self) -> Option<&Json>;

Open source →

0.16.626 Oct 20213 sources agree

[[#171]] Fix bug in Condition::add where Condition negation is ignored

[#171] Fix bug in Condition::add where Condition negation is ignored

Open source →

0.16.530 Sept 20213 sources agree

[[#149]] Fix SQLite chrono::NaiveTime binding

[#145] Add Condition::not
[#149] Fix SQLite chrono::NaiveTime binding

Open source →

0.16.426 Sept 20213 sources agree

Fix table drop options for SQLite

Fix table drop options for SQLite
Add IndexCreateStatement::is_unique_key()

Open source →

0.16.317 Sept 20213 sources agree

[[#131]] InsertStatement accepts SimpleExpr

[#131] CAST AS expression
[#131] InsertStatement accepts SimpleExpr
[#137] SQLx Postgres driver bind DateTime<FixedOffset>

Open source →

0.16.215 Sept 20213 sources agree

[[#120]] Support RETURNING for DeleteStatement

[#120] Support RETURNING for DeleteStatement
[#128] Support UNION clause for SelectStatement

Open source →

0.16.110 Sept 20213 sources agree

[[#129]] MySql ColumnType::Binary(None) maps to "blob"

[#129] MySql ColumnType::Binary(None) maps to "blob"

Open source →

0.16.02 Sept 20213 sources agree

[[#112]] Introduce Nullable trait to permit custom Option

[#112] Introduce Nullable trait to permit custom Option<T>
[#113] ValueType trait should have a non-panic-ing method
[#114] ValueType revamp
1. Remove ValueTypeDefault
2. Change type_name to return String
[#115] Postgres concatenate operator (||)
[#117] Lock support (FOR SHARE, FOR UPDATE) for SELECT statement

Open source →

0.15.021 Aug 20213 sources agree

[[#107]] Revamp Value to typed null value

[#107] Revamp Value to typed null value
Added BigDecimal support

The Value::Null variant is removed. You have to use a specific variant with a None.

Before:

Query::insert()
    .values_panic(vec![
        Value::Null,
        2.1345.into(),
    ])

After:

Query::insert()
    .values_panic(vec![
        Value::String(None),
        2.1345.into(),
    ])

Since we cannot handle the generic Null value on JSON, we removed the json method on InsertStatement and UpdateStatement. The following NO LONGER WORKS:

let query = Query::insert()
    .into_table(Glyph::Table)
    .json(json!({
        "aspect": 2.1345,
        "image": "24B",
    }));

let query = Query::update()
    .table(Glyph::Table)
    .json(json!({
        "aspect": 2.1345,
        "image": "235m",
    }));

In addition, if you constructed Value manually before (instead of using into() which is unaffected), you have to wrap them in an Option:

Before:

let (sql, values) = query.build(PostgresQueryBuilder);
assert_eq!(
	values,
	Values(vec![Value::String(Box::new("A".to_owned())), Value::Int(1), Value::Int(2), Value::Int(3)]))
);

After:

let (sql, values) = query.build(PostgresQueryBuilder);
assert_eq!(
	values,
	Values(vec![Value::String(Some(Box::new("A".to_owned()))), Value::Int(Some(1)), Value::Int(Some(2)), Value::Int(Some(3))]))
);

Open source →

0.14.229 Aug 2021

Nothing published for this version

Your coding agent can read these notes before it upgrades. Set up the MCP server →

sea-query

Release timeline

Releases

Enhancements

New Features

Bug Fixes

Upgrades

Breaking changes

sea-query-derive 0.4.1 - 2023-10-19

Bug Fixes

Enhancements

Versions

New Features

Enhancements

Bug Fixes

Breaking changes

Versions

Notes

Versions

New Features

Enhancements

Breaking changes

House keeping

Bug fixes

Bug fixes

Enhancements

Enhancements

Bug fixes

New Features

API Additions

Enhancements

Bug fixes

Breaking changes

Deprecations

House keeping

New Features

Enhancements

Bug Fixes

Breaking changes

House keeping

Upgrades

New Features

Bug Fixes

Bug Fixes

House keeping

Bug Fixes

New Features

Enhancements

Upgrades

Breaking changes

New features

Enhancements

Enhancements

New Features

Enhancements

Bug fixes

Breaking Changes

Bug fixes

Enhancements

Bug fixes

Enhancements

Bug fixes

New Features

Enhancements

Bug fixes

Breaking changes

New Features

Enhancements

Bug fixes

Breaking changes

New Features

Breaking Changes

New Features

Enhancements

Bug Fixes

Merged PRs

Merged PRs

Merged PRs

Merged PRs

Merged PRs

`sea-query-derive` 0.4.1 - 2023-10-19