Path: | doc/release_notes/4.11.0.txt |
Last Update: | Thu Nov 12 08:45:04 +0000 2015 |
The new json and jsonb functions and operators added in 9.4 are now supported in the pg_json_ops extension. You can use the jsonb functions and operators by creating a Postgres::JSONBOp using Sequel.pg_jsonb_op.
Sequel.as(:table, :alias, [:c1, :c2]) # table AS alias(c1, c2)
Not all databases support this, but it is in SQL92 and Sequel now supports it by default. Derived column lists make it easier to alias columns when using set-returning functions.
Dataset#from_self now supports derived column lists via the new :column_aliases option (which requires the :alias option to take effect).