2022 SQL improvements¶

The following SQL improvements were introduced in 2022:

Date released	Improvement	Impact
November 2022	New EXCLUDE and RENAME parameters in the SELECT command.	You can now select all columns and specify that you want to exclude or rename specific columns.
November 2022	New ARRAY_EXCEPT and ARRAY_DISTINCT functions.	You can now easily select the array elements that are in one array but not in another array. You can easily get the distinct elements in an array.
May 2022	New REGEXP_SUBSTR_ALL function.	You can now easily extract the substrings that match a regular expression from a string.

Date released

Improvement

Impact

November 2022

New EXCLUDE and RENAME parameters in the SELECT command.

You can now select all columns and specify that you want to exclude or rename specific columns.

November 2022

You can now easily select the array elements that are in one array but not in another array.

You can easily get the distinct elements in an array.

May 2022

You can now easily extract the substrings that match a regular expression from a string.