Perl.social | Community

1 year ago from Feed •

SQL DDL transformations and more

Changes for 1.63 - 2023-02-23

sqlt-diff: Change producer_args to sqlt_args for better self-documentation NOTE - using producer_args will now throw a deprecation warning
FEATURES
A lot of new functionality for the Oracle producer (thanks @hazardv)
Support DB commments in the following producers: PG, JSON, YAML. Also in the sqlite parser (thanks @djerius)
Support INCLUDE on indices for Pg (producer + parser)
Postgres producer now supports materialized views via $extra->{materialized}
FIXES
Postgres producer genrates correct constraint names for schema-namespaced tables
Postgres DBI parser now returns scalarref SQL instead of strings for defaults (thanks @nrdvana)
Postgres producer drops NOT NULL constraints more correctly (thanks @uehara-delta)
binaries now have their perl set by EUMM (thanks @toddr)

^metacpan.org

1 year ago from Feed •

A SQL Database object abstraction class

Changes for v0.11.0 - 2022-12-22T21:35:05Z

Minor correction to method format_update() in DB:😮bject::Query
Implemented handling of use of unknown fields (via the $tbl->fo->some_field mechanism)
Created new Module DB:😮bject::Fields::Unknown
Updated methods _group_order(), _where_having() in DB:😮bject::Query
Updated _process_limit in DB:😮bject::Query to take under account user-specified placeholders
Also updated DB:😮bject::Mysql::Query, DB:😮bject:😛ostgres::Query and DB:😮bject::SQLite::Query