The SQL::Statement module implements a pure Perl SQL parsing and execution engine. While it by no means implements full ANSI standard, it does support many features including column and table aliases, built-in and user-defined functions, implicit and explicit joins, complex nested search conditions, and other features.
SQL::Statement is a small embeddable Database Management System (DBMS). This means that it provides all of the services of a simple DBMS except that instead of a persistent storage mechanism, it has two things: 1) an in-memory storage mechanism that allows you to prepare, execute, and fetch from SQL statements using temporary tables and 2) a set of software sockets where any author can plug in any storage mechanism.
There are three main uses for SQL::Statement. One or another (hopefully not all) may be irrelevant for your needs: 1) to access and manipulate data in CSV, XML, and other formats 2) to build your own DBD for a new data source 3) to parse and examine the structure of SQL statements.
Package Version | Update ID | Released | Package Hub Version | Platforms | Subpackages |
---|---|---|---|---|---|
1.414-bp156.3.1 info | GA Release | 2023-07-22 | 15 SP6 |
|
|
1.414-bp155.2.8 info | GA Release | 2023-05-17 | 15 SP5 |
|
|
1.414-bp154.1.13 info | GA Release | 2022-05-09 | 15 SP4 |
|
|
1.412-bp153.1.13 info | GA Release | 2021-03-06 | 15 SP3 |
|
|
1.412-bp152.3.15 info | GA Release | 2020-04-16 | 15 SP2 |
|
|
1.412-bp151.3.1 info | GA Release | 2019-07-16 | 15 SP1 |
|
|
1.412-bp151.2.12 info | GA Release | 2019-05-18 | 15 SP1 |
|
|
1.412-bp150.2.4 info | GA Release | 2018-07-30 | 15 |
|
|