Releases: SeaQL/sea-query
Releases · SeaQL/sea-query
0.24.1
0.24.0
New Features
- Add
LOWER
andUPPER
func #276 - Insert
ON CONFLICT
support #279 - #174 Add support for
WINDOWS
statement #271 - #142 full support lock in select #289
- #269 add support for postgres
ANY
,SOME
,ALL
#283
Enhancements
- Add support for multiple
ALTER
operations #277 - #229 add column if not exists #278
- #255 Add support to CommonTableExpression columns method #284
- #280 Rewrite drivers using proc-macro #292
Bug fixes
Breaking changes
- The enum variants for
LockType
were renamed:Exclusive
->Update
andShared
->Share
- As part of #283, the drivers are split to the
sea-query-driver
crate- Remove methods
Value::is_json
andValue::as_ref_json
when feature: with-json is disabled - Remove methods
Value::is_time_*
andValue::as_ref_time_*
when feature: with-time is disabled - Remove methods
Value::is_chrono_*
andValue::as_ref_chrono*
when feature: with-chrono is disabled - Remove methods
Value::is_decimal
,Value::as_ref_decimal
andValue::decimal_to_f64
when feature: with-rust_decimal is disabled - Remove methods
Value::is_big_decimal
,Value::as_ref_big_decimal
andValue::big_decimal_to_f64
when feature: with-bigdecimal is disabled - Remove methods
Value::is_uuid
andValue::as_ref_uuid
when feature: with-uuid is disabled - Remove methods
Value::is_array
andValue::as_ref_array
when feature: postgres-array is disabled
- Remove methods
0.23.0
New Features
- Supports
time
in addition tochrono
#267
Enhancements
- Allow for trailing commas in any and all macros #270
Bug fixes
- Fix UNIQUE table index expression syntax for sqlite #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
.
0.22.0
New Features
- Support multiple tables in the select from by @Sytten in #261
- Add support for replace insert by @Sytten in #262
- Add
ColumnType
unsigned integer types by @billy1624 in #211
New Contributors
Full Changelog: 0.21.0...0.22.0
0.21.0
Breaking Changes
- Use double quotes for quuoting identifgiers for SQLite by @SpyrosRoum in #221
New Features
- Implement
RETURNING
for SQLite by @SpyrosRoum in #194 - Support 'NULLS LAST' and 'NULLS FIRST' by @qyihua in #210
- [join-lateral] by @rex-remind101 in #224
- Insert from select by @05storm26 in #238
- Add Expr::asterisk() and Expr::tbl_asterisk(table: DynIden) methods - Fix #217 by @RomainMazB in #219
Enhancements
- Implement ToTokens for IntervalField by @autarch in #195
- Implemented 'Array' type for Postgres. by @kev0960 in #205
- Add
Value::DateTimeLocal
by @billy1624 in #249 - Add
ColumnRef::SchemaTableColumn
by @billy1624 in #206 - Datetime utc by @tyt2y3 in #241
- Support the use of chrono::DateTime using the type alias DateTim… by @charleschege in #222
Bug Fixes
- Fix PostgreSQL
ColumnType::TinyInteger
mapping by @billy1624 in #207 - PR without clippy warmings in file changed tab by @billy1624 in #212
New Contributors
- @SpyrosRoum made their first contribution in #194
- @RomainMazB made their first contribution in #219
- @kev0960 made their first contribution in #205
- @qyihua made their first contribution in #210
- @rex-remind101 made their first contribution in #224
- @charleschege made their first contribution in #222
Full Changelog: 0.20.0...0.21.0
0.20.0
- Add
TableRef::DatabaseSchemaTable
by @billy1624 in #193
Full Changelog: 0.19.4...0.20.0
0.19.4
Merged PRs
- Binding
DateTime<FixedOffset>
for SQLx MySQL & SQLite by @billy1624 in #197
Full Changelog: 0.19.2...0.19.4
0.19.2
Merged PRs
- Impl
ValueTuple
Up to Six by @billy1624 in #200 - Basic Benchmark by @tyt2y3 in #192
Full Changelog: 0.19.1...0.19.2
0.19.1
Merged PRs
driver/postgres
handle non-exhaustiveValue
by @billy1624 in #191
Full Changelog: 0.19.0...0.19.1
0.19.0
Merged PRs
TableCreateStatement
andTableDropStatement
takes anyIntoTableRef
table name. by @Josh-codes in #186- Add
ColumnType::Enum
by @billy1624 in #188 - Update to Rust Edition 2021 by @billy1624 in #189
New Contributors
- @Josh-codes made their first contribution in #186
Full Changelog: 0.18.2...0.19.0