Disable the legacy macro


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.

Thank you!






Adrien Ragot (Play SQL / Requirement Yogi)


Adrien Ragot (Old account)