v.20.10New Feature

Now insert statements support asterisk with column transformers

Now insert statements can have asterisk (or variants) with column transformers in the column list. #14453 (Amos Bird).
Allows INSERT statements to use an asterisk (*) with column transformers in the column list.

Why it matters

This feature enables users to write more concise INSERT queries by applying transformations directly to all columns via an asterisk, simplifying data insertion and reducing duplication when modifying columns on insert.

How to use it

In your INSERT statement, use an asterisk () or its variants in the column list and apply column transformers to modify columns on the fly. For example:

INSERT INTO table_name (  -> transformer ) VALUES (...);