Sequel 5.96.0 Released

[jeremyevans]

Sequel 5.96.0 has been released!

New Features

• On PostgreSQL 9.2+, alter_table now supports a rename_constraint
  method, to rename an existing constraint:

    DB.alter_table(:table) do
      rename_constraint(:old_name, :new_name)
    end

• Virtual generated columns are now supported on PostgreSQL 18+,
  using the :generated_always_as and :virtual options. For backwards
  compatibility, the default without the :virtual option still
  creates a stored generated column. This is unfortunately different
  from the PostgreSQL 18+ default, where VIRTUAL is assumed if neither
  VIRTUAL nor STORED is specified.

• The strip_nulls method in the pg_json_ops extension now supports an
  :in_arrays option on PostgreSQL 18+, for stripping nulls in json
  arrays.

• The pg_array_ops extension now supports sort and reverse methods,
  for the array_sort and array_reverse database functions added in
  PostgreSQL 18.

Other Improvements

• When using the pg_range and/or pg_multirange extensions in
  conjunction with the the pg_auto_parameterize extension, PostgreSQL
  range and multirange types containing non-value expressions will no
  longer be automatically parameterized. Note that in order for Sequel
  to generate appropriate SQL for range types with a non-value
  expressions, the range must have an explicit type, as PostgreSQL
  does not offer a function to create an untyped range.

• A regression in 5.95.0 where the :deferred option would be ignored
  for unique and primary key constraints on PostgreSQL has been
  fixed (fix originally included in 5.95.1).

Thanks,
Jeremy