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).
Why it matters
This feature enables users to write more conciseINSERT 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 yourINSERT 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 (...);