Sequel v5.27.0 Release Notes

Release Date: 2019-12-01 // 12 days ago
    • ➕ Add Sequel::DEFAULT for a DEFAULT expression, useful for assigning to default values (jeremyevans)

    • Make Postgres::ArrayOp#join in pg_array_ops extension work correctly on PostgreSQL <9.1 (jeremyevans)

    • 👉 Make pg_enum extension work correctly on PostgreSQL 8.3-9.0 (jeremyevans)

    • 👍 Emulate FILTER clause for aggregate functions using CASE on databases not supporting it directly (jeremyevans)

    • 👌 Support ordering by NULLS FIRST/NULLS LAST without emulation on SQLite 3.30+ (jeremyevans)

Previous changes from v5.26.0

    • Recognize two additional foreign key constraint violation codes on MySQL 8.0.13+ (rianmcguire) (#1657)

    • 👌 Support table aliases for single-table INSERT statements on PostgreSQL 9.5+ (jeremyevans) (#1656)

    • Implement Sequel::Postgres::PGRange#hash so instances work correctly in hashes (jeremyevans) (#1648)

    • Make dirty plugin work correctly with typecast_on_load plugin (jeremyevans) (#1647)

    • Add support for :require_modification option when setting up nested_attributes (jeremyevans)

    • Add support for SQL/JSON path expressions to the pg_json_ops extension, supported by PostgreSQL 12+ (jeremyevans)