Extensions to SQL Standards
- Last Updated: October 3, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
Extensions to SQL Standards
The XML driver uses SQL grammar that is compliant with entry level ANSI SQL-92. The following table summarizes significant extensions to the grammar.
| Entry Level ANSI SQL-92 Extension | Relevant Standard or Convention |
|---|---|
| Aliasing table references | Intermediate level ANSI SQL-92 |
| ANSI date, time, and timestamp literals | Intermediate level ANSI SQL-92 |
| Dynamic parameter specification | Full level ANSI SQL-92 |
| GUID literals | COM |
| Hex string literals | Full level ANSI SQL-92 |
| Left Outer Joins | Intermediate level ANSI SQL-92 |
| ODBC escape support | ODBC 3.0 |
| Scalar functions | ODBC 3.0 |