There's a big difference between wire and syntax compatibility. This compatibility matrix does a nice job of showing the differences between vendors. But yeah, purpose-built databases have a place.