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