What art the pros and cons of having a database language based on an industry accepted standard?

btb6132 used Ask the Experts™
What are the benefits to a standardized database language like SQL and what are the drawbacks? What are the benefits and drawbacks to an accepted industry standard of a Structured Query Language?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
David VanZandtOracle Database Administrator III
1.  It follows industry standards.  Obvious value.
2.  It follows industry standards.  Awkward to customize.
3.  There are Standards, and then there are standards.  To wit, Microsoft and Oracle have had competing standards.

Seriously, though, I would not want to think of working with a 21st century architecture that was incompatible across different platforms, or different vendors.
Fixer of Problems
Most Valuable Expert 2014
I wrote software 20 years that required me to create my own database code.  It took about three months to do that.  There were no software utilities that I could use to do anything with that database.

The number one benefit of SQL is that it makes things fairly easy.  With SQL, there are many utilities to work with and interfaces built into most programming languages.  To duplicate even part of what MySQL or Microsoft SQL Server do would take years.

There are database that use languages other than SQL.  They are usually for more difficult problems, not easier ones.
Most Valuable Expert 2012
Distinguished Expert 2018

This sounds a lot like a homework or exam question.

I caution fellow Experts to pay attention to:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial