Programming languages take much more into consideration. Like ergonomics, backwards compatibility, user requests, etc.
Why should Relationship algebra have a pivot func? It doesn't. But a database engine might.
Compare relational algebra to Oracle/Postgres/My SQL for instance.