view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

        - Skip unnecessary step when extended values/arguments are disabled.

2.435  2025-10-14
        - Input filter empty columns: bugfix and update.
        - DBD::ODBC: added odbc_ignore_named_placeholders attribute.

2.434  2025-10-05
        - Allow existing CTEs to be used in the WHERE clause of UPDATE and DELETE statements.
        - DBD::Oracle: fixed DSN setup.
        - DBD::Oracle: new option "AskIfSid".

2.433  2025-09-29
        - SQLite: Respect the "sqlite_see_if_its_a_number" option when quoting constants.

2.432  2025-09-26
        - Firebird: bugfix in add-database.
        - Pg: update auto-convert-to-text.
        - Bugfix: don't allow different quoting for column names and aliases, as aliases could be used as column names later on.
        - Bugfix: set the default for "add alias for tables in join" to auto.
        - Unicode 17.

2.431  2025-06-06
        - Update history for date_add and data_substract.
        - Update available columns for extended expressions.
        - Makefile.PL: added back the 'dist' section.

2.430  2025-05-13
        - Update aggregate functions 'count' and 'group_concat'.
        - Term::TablePrint minimum version 0.172.
        - New option 'maximum with expanded table row'.

2.429  2025-05-05
        - Term::TablePrint minimum version 0.171.
        - Added 'List::MoreUtils::XS' to prereq_pm.
        - New option 'Pad Row Edges'.

2.428  2025-04-27
        - Perl minimum version 5.16.0.
        - Term::TablePrint minimum version 0.170.
        - Bugfix for Perls prior to 5.26.0: do not use ternary operator with bare length.
        - Check the 'realpath' return value.

2.427  2025-04-10
        - Term::TablePrint minimum version 0.169.
        - Term::Choose::Util minimum version 0.145.
        - Update aggregate mode in group_by.
        - Code refactoring.

2.426  2025-03-24
        - Term::Choose minimum version 1.769.
        - Update 'line_fold'.
        - Bugfix in input filter 'merge_rows' info output.

2.425  2025-03-23
        - Filter 'convert date': skip empty cells.
        - Union: the option 'edit statement' replaces the option 'where'.
        - Refactored union.
        - Bugfix in group_by.
        - Improved info output functions.
        - Update menus.
        - Let the user decide which ctes to remove.

2.424  2025-03-09
        - Update aggregate mode.
        - Bugfix SQLite, first_column_is_autoincrement: tablenames in sqlite_master are not qualified.
        - Refactored ScalarFunctions.
        - Improved info nested functions.
        - New date functions.
        - Different bugfixes.
        - New sql options.
        - Don not restrict 'On clause' operators.
        - Limit and offset: each has its own sql-menu entry.
        - Term::Choose minimum version 1.768.

2.423  2025-01-27
        - Bugfix undefined data type.
        - Bugfix where clause: reset and/or connector.
        - Added multi-column extension.
        - Bugfix extended columns: use normal columns if inside an aggregate functions.
        - Subqueries in ctes: do not show ctes twice.

2.422  2025-01-23
        - Extension 'Column': it is now possible to use a column from a chosen table.
        - A new way to create subqueries: build the subquery using the sql menu.
        - Update input filter Range_Rows
        - Added the exists and not exists operator.
        - Update and delete statement: do not remove the table alias.

2.421  2025-01-09
        - Update join condition.
        - Update join menu and union menu.
        - Update function 'group_concat' and the respective equivalents.
        - Don't delete the alias of a column if the column has been removed from the selected columns.
        - String functions and Postgress: convert automatically to text if a column is not char and not varchar.
        - Removed backwards compatibility layer for old search_and_replace settings storage format.

2.420  2024-12-27
        - New option: use aliases in 'group by', 'having' or 'order by'.

2.419  2024-12-20
        - Update input filter Range_Rows.

2.418  2024-12-18
        - Update input filter Choose_Rows.
        - New input filter Empty_Rows.
        - Text::CSV_XS: use 'getline_all' instead of 'getline'.

2.417  2024-11-17
        - Confirm update/delete without where clause.

2.416  2024-10-28
        - Term::Choose minimum version 1.767.

2.415  2024-09-05
        Extended argument 'column': use horizontal format.

2.414  2024-06-13
        - Bugfix Informix 'not matches'.
        - Bugfix in 'replace' function: allow empty replacement string.
        - Bugfix Informix 'day_of_week'.