July 08-12, 2024 — 8.25 Release Notes¶

Wildcards are now supported in OBJECT constants¶

You can now use wildcards in OBJECT constants. When you construct OBJECT data, you can use a wildcard by specifying {*}. The SQL statement constructs the OBJECT value from the specified data using the attribute names as keys and the associated values as values. Specifying {*} is equivalent to specifying OBJECT_CONSTRUCT(*).

For example, the following SQL statement uses a wildcard to construct OBJECT data:

SELECT {*} FROM my_table;

For more information, see OBJECT constants.