Last Update: 2023-04-01 07:30:20 -0700

New Features

  • A set_literalizer extension has been added, for treating Set instances in datasets similar to Array instances:

    DB.extension :set_literalizer
    DB[:table].where(column: Set.new([1, 2, 3]))
    # SELECT FROM table WHERE (column IN (1, 2, 3))


  • Sequel now avoids the use of singleton classes for datasets on Ruby 2.4+, instead creating a regular subclass whenever a dataset would be extended via extension or with_extend. This significantly improves performance, up to 20-40% for common dataset usage, because it avoids creating new singleton classes for every dataset clone, and it allows for cached method lookup.

  • Database#tables and views now support a :qualify option on Microsoft SQL Server to returned qualified identifiers.

  • The schema_dumper extension can now dump tables in non-default schemas when using Microsoft SQL Server.

  • The schema_dumper extension now correctly dumps string column sizes when using Microsoft SQL Server.

Backwards Compatibility