[tpetry]

All of your examples are vendor specific extensions to SQL. Nothing of that is part of the standard. So you are effectively hating a specific implementation which is not that logical.

[extrememacaroni]

Imagine hating the things that you use rather than a pdf with text, fascinating.

[zvrba]

Yes, ANSI syntax is surely composable or dynamic: EXTRACT(YEAR FROM DATE '1998-03-07')