2023 SQL improvements

The following SQL improvements were introduced in 2023:

Date releasedImprovementImpact
August 2023

New ARRAY_MIN, ARRAY_MAX, and ARRAY_SORT functions.

You can now easily select the array elements with the lowest value and the highest value.

You can easily get a sorted array of elements.

August 2023New ILIKE and REPLACE parameters in the SELECT command.

You can now select all columns that match a pattern containing SQL wildcards.

When selecting all columns, you can replace the value of specific columns with expressions.

July 2023New ALL keyword in the GROUP BY construct.You can group results by all non-aggregate columns in the SELECT list without having to specify each column by name.
February 2023

Support for bankers’ rounding (rounding half to even) in the ROUND function.

You can now use bankers’ rounding when rounding values.
January 2023New MIN_BY and MAX_BY functions.You can find the row containing the minimum or maximum value in a column and retrieve the value from a different column.