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...

SQL::Statement::Term is an abstract base class providing the interface for all terms....

This package contains support for the internally used SQL::Statement::RAM::Table....

This package contains support for "$dbh-"get_info()>....

This module contains the built-in functions for SQL::Parser and SQL::Statement. All of the functions are also available in any DBDs that subclass those modules (e.g. DBD::CSV, DBD::DBM, DBD::File, DBD::AnyData, DBD::Excel, etc.). This documentation c...

This package contains three utility classes to handle deliverable columns....

This package implements a factory to create type and operation based terms. Those terms are used to access data from the table(s) - either when evaluating the where clause or returning column data. The concept of a factory can be studied in *Design P...

SQL::Statement::Placeholder implements getting the next placeholder value. Accessing a specific placeholder is currently unimplemented and not tested....

SQL::Statement::Operation is an abstract base class providing the interface for all operation terms....

SQL::Statement::Function is an abstract base class providing the interface for all function executing terms....

This module requires almost everything what could be used by SQL::Statement to run more test cases....

This distribution contains several SQL functions to be used with SQL::Statement: YEAR() MONTH() DAYOFYEAR() DAYOFMONTH() DAY() WEEKOFYEAR() WEEKDAY() They are based on MySQL's version. More functions wil be added as needed. To use a function from Per...

This distribution contains several SQL functions to be used with SQL::Statement: IF() To use a function from Perl script: require SQL::Statement::Function::ByName::IF; $dbh->do(qq{CREATE FUNCTION IF NAME "SQL::Statement::Function::ByName::MAXNUM::SQL...

This distribution contains several SQL functions to be used with SQL::Statement: ARGMAXNUM() ARGMAXSTR() ARGMINNUM() ARGMINSTR() These functions are not aggregate functions. They are added due to the lack of CASE statement as well as IF function in S...

This module implements two classes that can be used for deriving subclasses to evaluate SQL::Statement objects. The SQL::Eval object can be thought as an abstract state engine for executing SQL queries and the SQL::Eval::Table object is a table abstr...

SQL::Parser is part of the SQL::Statement distribution and, most interaction with the parser should be done through SQL::Statement. The methods shown above create and modify a parser object. To use the parser object to parse SQL and to examine the re...

Caveat: the notion of true and false follows Perl's notion. Caveat: due to the current limitation of SQL::Parser, this function is not as useful as it should be, e.g. SQL::Parser cannot parse this correctly: SELECT IF(col > 10, a, b) FROM table...

Implements DAY() SQL function. It is synonym for DAYOFMONTH()....

Implements YEAR() SQL function. Syntax: YEAR(date) Return integer (e.g. 2015), or undef if argument is not detected as date....