Post

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

19/11/24, 7:57 am2 reposts14 likes

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.