0.24.1

Enhancements

• #295 Add parameter for SQLx path to proc-macro #297

Bug fixes

• CTE optional columns #301

0.24.0

New Features

• Add LOWER and UPPER 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

• #285 Fix timestamp_with_time_zone_len #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

0.23.0

New Features

• Supports time in addition to chrono #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

• @Sytten made their first contribution in #261

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-exhaustive Value by @billy1624 in #191

Full Changelog: 0.19.0...0.19.1

0.19.0

Merged PRs

• TableCreateStatement and TableDropStatement takes any IntoTableRef 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