Sad there are so many dialects. Ideally each would converge on standard SQL and the standard would adopt enhancements as they become widespread. Much like vender prefixing in CSS.
Then one wouldn't need bespoke features except temporarily or where they are truly necessary for the business.