Mimer SQL Standard Compliance

The language SQL (Structured Query Language) is standardized by international standard bodies such as ISO and ANSI. By using standard SQL it should be easier to move applications between different database systems without the need to rewrite a substantial amount of code. Using standard SQL does not give any warranty though as all vendors do not implement all features in the standard.

Mimer Information Technology’s policy is to develop Mimer SQL as far as possible in accordance with the established standard. Today, Mimer SQL is compatible in all essential features with the currently accepted SQL standards, which enables users to switch to and from Mimer SQL easily.

In order to assist database developers in writing SQL that conforms to the SQL standard, the Mimer SQL Validator is provided as a free online tool.

SQL Standard Topics

SQL Standard Features

Ensure that your SQL isn’t caught in the vendor-specific trap. You can maintain portability using our Mimer SQL Validators to test that your SQL statements conform to the SQL standard, and to what standard level they reside.

The following chart summarizes the Core SQL standard features. It also indicates how well Mimer SQL supports the core features.

The following chart summarizes the Optional SQL standard features. It also indicates which optional features that are currently supported by Mimer SQL.

Reserved Words

In the wonderful world of SQL, there are two kinds of reserved words: SQL reserved words and vendor-reserved words. When designing and writing applications, you should always avoid using vendor-reserved words as they severely limit portability.

Find out exactly who is reserving all those words and making it more difficult to write portable applications. Use the Mimer Validator – it will tell you exactly which words are reserved and who has reserved them.

Of course, Mimer SQL provides extensions, but the great thing is that we don’t use any additional reserved words.

See the following overview chart for reserved words in the SQL standard:

SQL Standard Organizations

So where can I get these standards? If you want your own copy of SQL Standards, you’ll have to purchase it. You can obtain a copy of ISO standards from the International Organization for Standardization at www.iso.org. The main identification for the standard is ISO/IEC 9075, which consists of several parts like for example “ISO/IEC 9075-1:2016 Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework)”.

If you would like to read more about SQL, we can recommend a search on your favorite Internet book site for the SQL authorities Joe Celko, Hugh Darwen, Chris Date or Jim Melton. Or visit our External resources page.