v.22.9Improvement

Fix APPLY Column Transformer Format to Prevent Metadata Issues

Fix incorrect format of APPLY column transformer which can break metadata if used in table definition. This fixes #37590. #40727 (Amos Bird).
Fixes the incorrect format of the APPLY column transformer in table definitions to prevent metadata corruption.

Why it matters

The update addresses a bug where using the APPLY column transformer with an incorrect format could break table metadata. This ensures table definitions remain consistent and stable when using column transformers.

How to use it

Users should define the APPLY column transformer in their table schema using the corrected format to avoid metadata issues. Existing table definitions using APPLY will benefit from this fix without requiring changes.