1 The SQL::Statement module implements a pure Perl SQL parsing and execution
2 engine. While it by no means implements full ANSI standard, it does support
3 many features including column and table aliases, built-in and user-defined
4 functions, implicit and explicit joins, complexly nested search conditions,
7 SQL::Statement is a small embeddable Database Management System (DBMS),
8 this means that it provides all of the services of a simple DBMS except that
9 instead of a persistant storage mechanism, it has two things:
10 1) an in-memory storage mechanism that allows you to prepare, execute, and
11 fetch from SQL statements using temporary tables and
12 2) a set of software sockets where any author can plug in any storage
15 There are three main uses for SQL::Statement.
16 1) to access and manipulate data in CSV, XML, and other formats
17 2) to build a DBD for a new data source
18 3) to parse and examine the structure of SQL statements.