SQL::Routine::Language 0.70.3 review

Download
by rbytes.net on

SQL::Routine::Language is a Perl module for what language or grammar SQL::Routine speaks. SQL::Routine contains SQL schemas and qu

License: Perl Artistic License
File size: 169K
Developer: Darren R. Duncan
0 stars award from rbytes.net

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 module's 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 can't 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::Routine's '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.

Requirements:
Perl

SQL::Routine::Language 0.70.3 keywords