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.

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

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

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