[Vintila]

Slightly off-topic but I love their sql docs[1], those diagrams are just beautiful.

[1] https://sqlite.org/lang_createtable.html

[contingencies]

They are semi-regularly discussed here, and are known as syntax diagrams or railroad diagrams. You can find a good list of generation tools at https://en.wikipedia.org/wiki/Syntax_diagram