SQL Table Macro

SQL Table Macro: create reusable SQL templates (FROM clause) you can pass tables and other parameters to at runtime.

Learn more:

• See Documentation
• See the Gist to get the source code

😁 and the second version of this SQL Macro is just born (the Gist has been updated): the macro now can take a column as a parameter as well making this a real tool reusable for all of my tables containing JSON arrays!

SQL Table Macro is a 21c feature backported to the 19.7 release update.

Kudos to Chris Saxon for helping a lot in finding the summary for such a great feature!