If you clicked on the macro link in the advanced tutorial and curiosity got the better of you, you'd notice that the Gallery and the dbt project that builds it, is much more than just macros.
In the dbt project that builds the Gallery, artworks are created as dbt models.
Any decent graphic design program (sorry MS Paint!) allows you to draw in layers. The SQL Draw Gallery project provides this via a custom materialization called new_layer. This means that instead of using
UPDATE statements to the canvas like we do from Slack, instead we write
SELECT statements that add a new layer to an existing layer below.
A big part of SQL Draw is community contributions.
You can contribute an artwork for others to admire, or you can contribute macros to help others build their own artworks. Or both!
To submit a contribution: