Exactly. The situation is even worse because many libraries support only "common ground of SQL" and therefore underutilize the real capabilities of the database.

We mentioned that there are "many SQLs" in this blog post, but not in this specific context.