If I wanted to make a suggestion to a change to how the UPDATE
statement works in SQL
, how would I go about it?
Is there a website for the next standard?
I googled, but just kept getting the Wikipedia page.
12
There are a couple of means to do this.
- Petition ISO
- Persuade your favorite DB vendor
- Make the change yourself
Petition ISO
You can petition your request to the appropriate committee(s) at ISO. The Wikipedia article you linked provides the ISO specification numbers and therefore which committees.
Be forewarned that you’ll probably need to volunteer on the committee(s) and / or put in a lot of work to champion this change. Having indirectly worked with standards committees before, I can assure you that nothing is straightforward and nothing occurs unless the change has a champion.
Persuade your favorite DB vendor
The DB vendors such as IBM, Microsoft, and Oracle are not obligated to code their databases against the SQL standard. Last I checked, none of them complied completely with the latest SQL standard anyway. If you have sufficient clout with the vendors, you may be able to persuade them to implement the change you are requesting. I would start with your local sales representative in this case.
All of the major DB vendors are (or should be) involved in the standardization process. If you can convince one of them to make the change for you, then they should be able to champion the change at the next evolution of the standard.
Make the change yourself
All that having been said, you’re more than welcome to pull a copy of the source for your favorite open source DBMS and make the change yourself. While this will likely require the most amount of effort on your part, it also has the best odds of actually seeing the light of day. Even if the project maintainers reject your enhancement, you can always run your version of the database and have the change you have requested.
If your change is adopted by the project and it proves popular, it could eventually find its way into the next version of the standard.
Well that standards are controlled by ANSI, so I would suggest you start there.
http://www.ansi.org/
Although as already said getting it in to the standards is unlikely, as mentioned from others there are ways of doing this already if you want to be explicit and more importantly your change wouldn’t be backwards compatible.