Revision history for Perl extension SQL::Maker

1.06    Sun Sep 16 04:30:50 UTC 2012

    - In SQL::Maker::Select
        - Add "add_where_raw" method. (issm)
    - In SQL::Maker::Condition
        - Add "add_raw" method. (issm)

1.05

    - support group_by at SQL::Maker->select

1.04

    - support $where as SQL::Maker::Condition at select, update and delete(nihen)
    - support joins at select

1.03

    - support INSERT statement without parameters on SQLite3.
      https://github.com/tokuhirom/SQL-Maker/issues/11
      (requested by forwardever++)

1.02

    - doc fix(reported by xaicron++)

1.01

    - support this form: ['created_on' => { '>', \'DATE_SUB(NOW(), INTERVAL 1 DAY)' }]

1.00

    - remove alpha tag.

0.14

    - Type check for clear error messages(gfx)
    - fixed testing issue on t/10_subquery.t(reported by gfx++)

0.13

    - In SQL::Maker
        - Allow 'INSERT IGNORE' by $opts->{prefix} params at insert() method (zigorou)
        - Accept key-value as array at insert() method (zigorou)
        - Accept value using subquery at insert(), update() method (zigorou)
        - Allow table alias at select() method (zigorou)
    - In SQL::Maker::Plugin::InsertMulti
        - Accept values as arrayref at insert_multi() (zigorou)
        - Allow 'INSERT IGNORE' by $opts->{prefix} params at insert_multi() (zigorou)
        - Allow literal and subquery in values at insert_multi() (zigorou)
        - Supports 'ON DUPLICATE KEY UPDATE' syntax on mysql driver at insert_multi() (zigorou)
    - In SQL::Maker::Select
        - Allow no conditional join (zigorou)

0.12

    SQL::Maker::Plugin::InsertMulti before 0.12 have a critical issue.
    I highly recomment version up to 0.12+, if you are using SQL::Maker::Plugin::InsertMulti.

    - FIX: SQL::Maker::Plugin::InsertMulti doesn't works correctly.
    - doc fix on SQL::Maker::Plugin::InsertMulti

0.11

    - added SQL::Maker#new_condition method(nekokak)

0.10

    - support union, intersect, except(makamaka)

0.09

    - allow SELECT object and alias to add_join(makamaka)

0.08

    - doc enhancements(tokuhirom)
    - support $builder->select(order_by => {foo => 'DESC'}) form for skinny

0.07

    - allow subquery in from clause(makamaka)

0.06

    - allow hashref in new_select() method

0.05

    - doc fix(lestrrat)

0.04

    - add space each comma on using IN statement(zigorou)

0.03

    - 60ded52 (HEAD, zigorou/master, origin/master, master) remove last new_line on as_sql(), add tests for different new args(zigorou++)
    - 1d54a09 add new_line opts to SQL::Maker, SQL::Maker::Select(zigorou++)
    - 0b84cd7 change the quote_char detection logic. see http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

0.02

        - added new method 'new_select'.
        - pod fix

0.01    Sat Nov 27 11:37:12 2010
        - original version