This project contains grammars for the ANSI SQL Standards (taken from
the drafts).
See the HTML rendered grammars here:
http://jakewheat.github.io/sql-overview/
TODO
Cover most of the SQL Standard:
explain what the concepts are. Document the names for these in the SQL
standard, and what names products use.
Focus mostly on grammar, but also on semantics. Explain and give
examples of sql source, and cover the availability of these in sql
products, mentioning the compatibility with the standard and other
products, and the jargon used for each product.
The reader should go away with:
* an understanding of what is in the standard and what the names of
things really mean
* an understanding of which bits of the standard are widely supported,
which bits are widely supported but with varying syntax or
behaviour, and which bits exist only in the minds of the sql
standards people and don't relate to reality
* an understanding of why features exist and what purpose they are for
* an understanding of which features are supported in a range of
common products
* a good and in depth appreciation for sql's strengths and weaknesses
Provisional product list ideas: db2, oracle, sql server, sap dbmss,
postgresql, mysql.
TODO: cross referenced grammar
What kinds of features are in the standards:
1 syntax which everyone supports
2 syntax which many dbmss support
3 features which many dbmss support with different syntax
4 features which many dbmss support, possibly with different syntax,
with not very similar semantics
5 features which no or very few dbmss support
-------
TOC ideas:
databases, tables, queries, updates
scalar types
type constructors: row, array, multiset
scalar expressions
dml
queries
queries
select list
table ref, joins
aggregates, group by, grouping sets
window functions
where, having
limit, offset
order by
set operations
cte
array unnest and variations?
subqueries, csq, lateral
updates
delete
truncate
insert
merge
update
cursors
temporary tables ??
ddl, schemas
tables, columns
defaults, identity, sequences
constraints, unique/pk, not null, referential, check
alter table
table periods, system versioning
other schema objects
locators??
transaction management
session management
catalog
access control
clients, servers, sessions, connections
databases, 'catalog clusters', and schemas
control statements
connection management
diagnostics
dynamic sql
embedded sql
direct invocation
procedural sql
external data
extensibility
call level interface
persistent stored modules
management of external data
object language bindings (java?)
information and definition schema
java
xml
--------------------------
postgres manual says that there are 179 mandatory features for 2011
core conformance, postgres does 160, and no database product does all
of these