Post

First session at #DOAG2024 by @andrejsql.bsky.social about SQL Macros. Lot of examples and ideas after a short introduction.

Another cool example print_table via SQL Macro

Or select * excluding some columns.

Yes, you can nest SQL Macros under certain circumstances. Finding duplicates with or without some example rows.

19/11/24, 8:14 am0 reposts1 like

Or SQL Macros for function names used in other SQL dialects without context switch.

And the SQL Transpiler replaces some use cases for scalar SQL Macros.