It's mostly fine and certainly has some advantages, but it also continues to have weird behavior that can randomly creep up. My recent favorite is[1]:

> MySQL parses but ignores “inline REFERENCES specifications” (as defined in the SQL standard) where the references are defined as part of the column specification.

Because of course it's very reasonable to accept a foreign key specification but completely ignore it.

[1]: https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-ke...