Here is a screenshot of the legacy macro, which most people don't use anymore:
We're proceeding to removing the Legacy SQL Macro in 2 steps:
2.11 We don't display the macro anymore in the autocomplete and we'll only allow sysadmins to use it. Existing macros will still work.
2.12 We'll completely remove the macro and the code.
It has been deprecated for 2 years,
All features (user parameters) were transferred to the new macro,
It requires maintaining a swarm of dedicated code. Too much code is bad because:
It pulls productivity down, so fewer features are developed for the other customers.
It reduces the exposure to risk. Every API needs to have checks for permissions, and the deprecated APIs are using the old permission scheme.
Workarounds and mitigation:
Replace the legacy macro with the normal Query macro,
If there is a problem with dropping this feature, avoid upgrading to the latest version and tell us what is holding you back.
Errors will be displayed in the logs when the deprecated features are being used and the identity of the user. This logging can be turned off using the system property -Dplaysql.mute-deprecation-warnings.