One major caveat for the SQLite diagrams in particular - they are written by hand, not from the computer-readable parser description. This means that there are

One major caveat for the SQLite diagrams in particular - they are written by hand, not from the computer-readable parser description. This means that there are sometimes blatant bugs and ambiguities. Test your AST assumptions against a real SQLite!