> if you have a deep understanding of theory of parsing and parser generators

No deepness needed, the only thing you need to know is recursion.

Also SQL is even better than that because every query is it's own statement, so the parsing is dead simple. I totally get why he did it this way.