Sequel 5.84.0 Released

[jeremyevans]

Sequel 5.84.0 has been released!

New Features

• The pg_json_ops extension now supports the json_exists, json_value,
  and json_query functions added in PostgreSQL 17:

    Sequel.extension :pg_json_ops
    j = Sequel.pg_json_op(:jsonb_column)
    j.exists('$.foo')     # json_exists(jsonb_column, '$.foo')
    j.value('$.foo')      # json_value(jsonb_column, '$.foo')
    j.query('$.foo')      # json_query(jsonb_column, '$.foo')
  
    j.exists('$.foo', passing: {a: 1}) # json_exists(jsonb_column, '$.foo' PASSING 1 AS a)
    j.value('$.foo', returning: Time)  # json_value(jsonb_column, '$.foo' RETURNING timestamp)
    j.query('$.foo', wrapper: true)    # json_query(jsonb_column, '$.foo' WITH WRAPPER)

  All clauses supported by PostgreSQL 17 are supported via options
  (supported options differ per method):

  • :on_error : ON ERROR
  • :on_empty : ON EMPTY
  • :passing : PASSING
  • :returning : RETURNING
  • :wrapper : WITH WRAPPER | OMIT QUOTES

• On SQLite, Database#create_table now supports a :using option to
  create a virtual table:

    DB.create_table(:t, using: 'fts5(email)')
    # CREATE VIRTUAL TABLE t USING fts5(email)
  

Other Improvements

• The gem size has been reduced 25% by removing documentation.

Thanks,
Jeremy