Log message:
databases/ruby-sequel: update to 5.79.0

5.79.0 (2024-04-01)

* Support create_or_replace_view with :materialized option on PostgreSQL
  (nashby) (#2144)

* Support :unlogged_tables_default Database option on Postgres for making
  created tables unlogged by default (jeremyevans) (#2134)

* Add Dataset#select_prepend for prepending to the current selected columns
  (jeremyevans) (#2139)

Log message:
databases/ruby-sequel: update to 5.78.0

5.78.0 (2024-03-01)

* Support SQLite 3.45+ jsonb functions in the sqlite_json_ops extension
  (jeremyevans) (#2133)

* Support compounds (e.g. UNION) in conjunction with Database#values on
  PostgreSQL (jeremyevans) (#2137)

* Support :use_advisory_lock option to Migrator.run to use advisory locks
  when running migrations (jeremyevans) (#2089)

* Support Database#with_advisory_lock on PostgreSQL, MySQL, and Microsoft
  SQL Server (jeremyevans) (#2089)

Log message:
databases/ruby-sequel: update to 5.77.0

5.77.0 (2024-02-01)

* Support create_table :without_rowid option on SQLite (loranger32) (#2126)

* Warn by default if trying to eager_graph/association_join an association
  that uses a block, when the block would be ignored (jeremyevans)

* Speed up validates_unique in validation_helpers plugin by using empty?
  instead of count == 0 (numbata) (#2122)

* Speed up regexp matches in sqlite adapter on Ruby 2.4+ (jeremyevans)

* Add sqlite adapter :regexp_function_cache option for specifying the cache
  object to use (paddor, jeremyevans) (#2116)

* Respect list plugin :top option when inserting the first row into the
  model's table (johanmagnusson) (#2115)

* Switch default connection pool to timed_queue on Ruby 3.4+ (jeremyevans)

* Support on_duplicate_columns={raise,warn} parameter in connection URL when
  using duplicate_columns_handler extension (jeremyevans)

* Add transaction_connection_validator extension for retrying transactions
  on new connection if ther is a disconnect error when starting transaction
  (jeremyevans)

Log message:
databases/ruby-sequel: update to 5.76.0

5.76.0 (2024-01-01)

* Improve performance and flexibility of regexp matching in sqlite adapter
  (paddor) (#2108)

* Support SQL::Identifier for Database#tables :schema option values on
  PostgreSQL (jeremyevans)

* Support generating rcte queries using UNION or UNION ALL in the rcte
  plugin (jonathanfrias) (#2107)

* Make Database#table_exists? on PostgreSQL handle lock or statement
  timeout errors as evidence the table exists (jeremyevans) (#2106)

* Work around DateTime.jd fractional second bug on JRuby in named_timezones
  extension (jeremyevans)

* Support fractional times and timestamps on SQLAnywhere (jeremyevans)

* Make round_timestamps extension use Dataset#sqltime_precision for
  rounding Sequel::SQLTime values (jeremyevans)

* Remove special handling of %N modifier in
  Dataset#default_timestamp_format (jeremyevans)

* Add Dataset#default_time_format private method, for adapters to override
  for time (not timestamp) formatting (jeremyevans)

* Remove Dataset#format_timestamp_offset private method (jeremyevans)

* Remove special handling of %z modifier in
  Dataset#default_timestamp_format (jeremyevans)

* Add Dataset#literal_date_or_time, for simpler use by bound argument code
  (jeremyevans)

* Add auto_cast_date_and_time extension, for casting date and time values
  using SQL standard functions (jeremyevans)

Log message:
databases/ruby-sequel: update to 5.75.0

5.75.0 (2023-12-01)

* Make any_not_empty? extension support passing pattern argument to any?
  (jeremyevans) (#2100)

* Respect :skip_transaction option in PostgreSQL Dataset#paged_each
  (jeremyevans) (#2097)

* Add TimestampMigrator.run_single to run a single migration file up or down
  (opya, jeremyevans) (#2093)

* Support INSERT RETURNING on MariaDB 10.5+, and use it when saving new
  model objects (jeremyevans)

* Add Database#{defer,immediate}_constraints on PostgreSQL for changing
  handling of deferrable constraints in a transaction (jeremyevans)

Log message:
databases/ruby-sequel: update to 5.74.0

5.74.0 (2023-11-01)

* Make generated columns show up in Database#schema when using SQLite 3.37+
  (jeremyevans) (#2087)
* Add revert method for Sequel.migration blocks, to revert changes inside
  the block on up, and apply the changes on down (jeremyevans)
* Re-add is_json and is_not_json methods to the pg_json_ops extension, as
  the support was re-added in PostgreSQL 16 (jeremyevans)
* Avoid infinite loop when handling exceptions with a cause loop in jdbc
  adapter (jeremyevans)

Log message:
databases/ruby-sequel: update to 5.73.0

5.73.0 (2023-10-01)

* Handle disconnect errors in ibmdb and jdbc/db2 adapters (jeremyevans) (#2083)

* Support skipping transactions in Dataset#{import,paged_each} using
  :skip_transaction option (jeremyevans)

* Add Database#transaction :skip_transaction option to skip creating a
  transaction or savepoint (jeremyevans)

* Stop using a transaction for a single query if calling Dataset#import
  with a dataset (jeremyevans)

* Add paged_operations plugin for paged deletes and updates and other
  custom operations (jeremyevans) (#2080)

* Support to_tsquery: :websearch option to Dataset#full_text_search on
  PostgreSQL 11+ (jeremyevans) (#2075)

* Add MassAssignmentRestriction#model and #column for getting the model
  instance and related column for mass assignment errors (artofhuman,
  jeremyevans) (#2079)

* Stop using base64 library in column_encryption plugin (jeremyevans)

Log message:
databases/ruby-sequel: update to 5.72.0

5.72.0 (2023-09-01)

* Sort caches before marshalling when using schema_caching, index_caching,
  static_cache_cache, and pg_auto_constraint_validations (jeremyevans)

* Change the defaults_setter plugin do a deep-copy of database default
  hash/array values and delegates (jeremyevans) (#2069)

* Add pg_auto_parameterize_in_array extension, for converting IN/NOT IN to =
  ANY or != ALL for more types (jeremyevans)

* Fix literalization of infinite and NaN float values in PostgreSQL array
  bound variables (jeremyevans)

Log message:
databases/ruby-sequel: update to 5.71.0

5.71.0 (2023-08-01)

* Support ILIKE ANY on PostgreSQL by not forcing the use of ESCAPE for ILIKE
  (gilesbowkett) (#2066)

* Add pg_xmin_optimistic_locking plugin for optimistic locking for all
  models without database changes (jeremyevans)

* Recognize the xid PostgreSQL type as an integer type in the
  jdbc/postgresql adapter (jeremyevans)

* Make set_column_allow_null method reversible in migrations (enescakir)
  (#2060)

Log message:
databases/ruby-sequel: upate to 5.70.7

5.70.0 (2023-07-01)

* Make static_cache plugin better handle cases where forbid_lazy_load plugin
  is already loaded (jeremyevans)

* Fix ShardedThreadedConnectionPool#remove_server to disconnect all
  connections if removing multiple servers (jeremyevans)

* Support SEQUEL_DEFAULT_CONNECTION_POOL environment variable for choosing
  connection pool when :pool_class Database option is not set (jeremyevans)

* Add sharded_timed_queue connection pool (jeremyevans)

* Make connection_{validator,expiration} and async_thread_pool extensions
  work with timed_queue connection pool (jeremyevans)

* Make connection_{validator,expiration} extensions raise error when used
  with single threaded pools (HoneyryderChuck, jeremyevans) (#2049)

* Workaround possible resource starvation in threaded connection pool
  (ioquatix) (#2048)