That guide lacks a warning I think we have somewhere else.
Point is, different adapters may generate SQL different even in little
details like quoting column names.
It is good that a note at the beginning mentions this. Then the guide
should choose an adapter in the same note, tell the reader, and stick
to that one in SQL examples. The natural one in my view is SQLite,
because it is Rails' default.