fatalmind / sql-overview Goto Github PK

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