Changes

Revision history for SQL-Abstract-More

1.43 05.03.2024
  - accept scalar in ->with(-columns => $scalar, ...) # this was documented but not implemented

1.42 22.01.2024
  - backcompat : accept select(-from => $arrayref) and select(-from => $scalarref)

1.41 21.01.2024
  - support for subqueries as columns in a select list or as a source in -from clause
  - new parameter ->select(... -as => $alias)
  - support table aliases on simple tables
  - internal refactorings for better clarity of the select() method

1.40 19.11.2023
  - new dialect "Oracle12c" for using query_limiting clauses in Oracle version 12c or greater
  - internals : replaced Module::Install by Module::Build

1.39 22.07.2022
  - back to SQL::Abstract::Classic as default parent class, because of
    compatibility issues with special_operators

1.38 02.04.2022
  - support -having without -group_by, since some DBMS admit this syntax (Rouzier++)

1.37 29.01.2021
  - avoid defined-or operator (//), not admitted in perl 5.8

1.36 28.01.2021
  - fix inheritance bug with SQL::Abstract v2.0 (RT#134151)
  - can inherit from SQL::Abstract::Classic through '-extends' arg to import()

1.35 24.01.2021
  - new arg -final_clause for with()
  - temporary fix for RT#134127 -- wait for resolution of RT#134128

1.34 01.01.2021
  - support for common table expressions (WITH RECURSIVE)
  - support for -add_sql parameter in insert/update/delete (additional SQL keywords)
  - support for insert(-select => ..)
  - internals :
     - rearrange update() because the parent method was refactored in SQLA 1.85
     - report errors through puke/belch instead of croak/carp
     - fixed tests for bind_params() -- no longer necessary to monkey patch DBD::Mock,
       and the old tests were plainly wrong !

1.33 14.01.2018
  - removed the option introduced in 1.32, replaced by new syntax for "USING"

1.32 08.01.2018
  - new option "join_with_USING"

1.31 12.12.2017
  - align _insert_values / _insert_value on new parent SQLA architecture
  - does() also handles overloaded SCALAR and CODE dereferencing and is
    visible by external modules

1.30 29.10.2017
  - fix typo in dependency on SQL::Abstract (require v1.84, not 1.74)

1.29 28.10.2017
  - syntax >=< for full outer joins
  - support for joins in update() (rouzier++)
  - support for -returning arg in update()
  - Respect +- prefixes for update and delete and allow binds for select order by (rouzier++)

1.28 05.07.2016
  - support for quoting table and column names
  - fix warning 'redundant' appeared in perl 5.22 

1.27 06.04.2015
  - added support for IN clauses with multicolumns

1.26 16.10.2014
  - RT 99455 : ignore initial or trailing spaces in column alias parsing

1.25 03.10.2014
  - fixed Scalar::Does dependency in Makefile.PL

1.24 03.10.2014
  - RT 99182 : recent versions of Scalar::Does are too heavy, drop the dependency

1.23 13.08.2014
  - bug fix, v1.22 no longer accepted syntax x|alias when x has length 1

1.22 09.08.2014
  - avoid interference of '|' for column aliases with builtin DBMS operators
  - also accept new() args as a hashref
  - run the whole SQLA test suite against SQLAM

1.21 20.04.2014
  - fix missing test dependency
  - switch to Module::Install

1.20 18.04.2014
  - support for -order_by/-limit in update() and delete() (MySQL accepts that!)
  - -limit => 0 is no longer ignored

1.19 01.02.2014
  - better implementation for bind values within join specifications

1.18 31.01.2014
  - added support for bind values (as quoted strings) within join specifications

1.17 22.07.2013
  - fixed incorrect treatment of -limit for "RowNum" dialect (used by Oracle)

1.16 16.07.2013
  - fixed doc for join() (description of the return value)
  - fix for RT 86895 (incorrect treatment of -order_by / -group_by)

1.15 18.04.2013
  - bind values with types : dropped syntax [$value, \%type] because of
    conflicts with "OR" clauses of shape [$condition1, \%condition2]; so
    only DBIx::Class-like syntax will be accepted

1.14 14.04.2013
  - fix bug introduced in v1.13 (return "" instead of return ())

1.13 14.04.2013
  - "looks_like_ternary_bind_param" renamed as "is_bind_value_with_type"
  - support for DBIx::Class syntax of bind values with types

1.12 08.04.2013
  - fix missing bits for supporting arrayrefs in insert(), update()
  - improvements in doc

1.11 07.04.2013
  - bind_params supports 3-args form of DBI::bind_param()
  - values in select(), insert(), update() can be arrayrefs [$value, \%type]

1.10 15.01.2013
  - support for -desc/-asc in -order_by (compatibility with SQL::Abstract)

1.09 08.12.2012
  - dependency on SQL::Abstract 1.73 because of -ident/-value

1.08 30.11.2012
  - [rt.cpan.org #81305] replace \'=foo.bar' by {'=' => {-ident => 'foo.bar'}}
  - [rt.cpan.org #81485] systematically order "keys %hash" for perl 5.17.6

1.07 20.10.2012
  - replace reftype tests by Scalar::Does
  - no longer warns on -where => {field => {-in => $scalar}}

1.06 02.08.2012
 - fix in test that no longer passed with SQL::Abstract::Test v1.73

1.05 31.05.2012
 - forgot dependency on MRO::Compat

1.04 29.05.2012
 - [rt.cpan.org #77374] Use namespace::clean instead of namespace::autoclean
 - added support for set operators (UNION/INTERSECT/MINUS/etc.)

1.03 17.03.2012
 - added support for Oracle INSERT ... RETURNING .. INTO ..
 - croak() instead of die() upon errors

1.02 13.03.2012
 - unbless arrayrefs passed to _where_field_IN, to make SQLA happy

1.01 08.03.2012
 - fixed sql_dialect for Oracle : no 'AS' keyword in table aliases

1.00 15.12.2011
 - added methods insert(), update(), delete()

0.06 13.12.2011
 - new parameter 'max_members_IN'

0.05 07.10.2011
 - limit_offset dialect "RowNum", for @§%#! Oracle

0.04 28.08.2011
 - doc fix, thanks to Terrence Brannon

0.03 07.08.2011
 - added dependency on 'parent.pm' in Build.PL

0.02 03.08.2011
 - Fixed stupid pod test

0.01 31.07.2011
 - First release (code extracted and refactored from DBIx::DataModel)