SQL parsing and processing engine
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.
- Developed at devel:languages:perl
- Sources inherited from project openSUSE:Factory
-
2
derived packages
- Download package
-
Checkout Package
osc -A https://api.opensuse.org checkout openSUSE:Leap:16.0:FactoryCandidates/perl-SQL-Statement && cd $_
- Create Badge
Source Files
Filename | Size | Changed |
---|---|---|
SQL-Statement-1.405.tar.gz | 0000138703 135 KB | |
perl-SQL-Statement.changes | 0000011631 11.4 KB | |
perl-SQL-Statement.spec | 0000003698 3.61 KB |
Revision 25 (latest revision is 32)
- updated to 1.405 [Bug fixes] * INSERT now expands incomplete rows (Thanks to H.Merijn Brand) Version 1.404, released May 23, 2013 ------------------------------------------------- [Bug fixes] * re-enable cleanup test_output* after test done * recommend Text::Soundex and do soundex-test only when have it, because it's going to be removed from core for Perl 5.19 (thank Merijn) Version 1.403, released May 22, 2013 ------------------------------------------------- [Bug fixes] * fix documentation (rt#84889 - thanks Xavier Guimard and Florian, rt#85257 - thanks Andreas Koenig) Version 1.402, released December 19, 2012 ------------------------------------------------- [Misc] * add Math::Complex 1.56 as recommendation (RT#81926, Sam Ferencik) * add Math::BigInt 1.88 as recommendation (RT#81927, Sam Ferencik) * clarify Test::Simple 1.90 is required for building (RT#81925, Sam Ferencik) [Bug fixes] * fix leaking reference to open tables outside SQL::Statement::execute (fixes RT#81523) * looks_like_number identifies 'nan' as number sometimes (add regex to t/06virtual.t)
Comments 0