Sequel 5.22.0 has been released!
= New Features
* Sequel now supports Ruby 2.7+ startless ranges in filters:
DB[:table].where(:column=>(..10))
# SELECT * FROM table WHERE (column <= 10)
DB[:table].where(:column=>(...10))
# SELECT * FROM table WHERE (column < 10)
It also supports startless, endless ranges in filters, using a
condition that is always true:
DB[:table].where(:column=>(nil..nil))
# SELECT * FROM table WHERE (1 = 1)
* Sequel now supports startless ranges in the pg_range extension:
DB.extension :pg_range
DB[:table].insert(:column=>(..10))
# INSERT INTO "table" ("column") VALUES ('[,10]') RETURNING "id"
DB[:table].insert(:column=>(...10))
# INSERT INTO "table" ("column") VALUES ('[,10)') RETURNING "id"
DB[:table].insert(:column=>(nil..nil))
# INSERT INTO "table" ("column") VALUES ('[,]') RETURNING "id"
* Sequel now supports a :materialized option in Dataset#with on
PostgreSQL 12+, to control the inlining of common table expressions:
DB[:t].with(:t, DB[:t2], :materialized=>false)
# WITH "t" AS NOT MATERIALIZED (SELECT * FROM "t2")
# SELECT * FROM "t"
DB[:t].with(:t, DB[:t2], :materialized=>true)
# WITH "t" AS MATERIALIZED (SELECT * FROM "t2")
# SELECT * FROM "t"
= Other Improvements
* Database#primary_key_sequence now works for tables without serial
sequences on PostgreSQL 12+.
* Dataset#multi_insert and #import with return: :primary_key option
on Microsoft SQL Server now work correctly if the dataset uses
a row_proc (e.g. for model datasets).
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/94c9e6c6-97af-468b-82dd-a685a4169521%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
