SQL::Routine::Language 0.70.3

SQL::Routine::Language is a Perl module for what language or grammar SQL::Routine speaks.

SQL::Routine contains SQL schemas and queries, represented as a tree of atomic tokens; it is structurally like an abstract syntax tree or an XML DOM, but one that only accepts, respectively, a specific source language or XML schema. See SQL::Routine for more details.

The modules API and code make it look like a generic tree, composed of related Nodes. The restrictions for which attributes each Node can have, and its relationship to others, is defined by data (though for efficiency, that data is also contained in the same module and cant be changed at runtime).

As an analogy, the module has an API like a generic XML DOM, but it can enforce a specific XML Schema (the data). The context in which it is used is like a generic database interface. The API basically has an "execute" function, to which a SQL string is given, within that, there is a huge amount of flexibility of what the SQL string can say, but it must conform to a specific grammar.

This document, SQL::Routine::Language, is meant to say what all the types of Nodes are, and what attributes and relationships are allowed for each. It is meant to say what grammar for SQL::Routines language is, or what schema it accepts.

The type of information this document would provide is functionally similar to the SQL design documents, or vendor-specific ones.